Table of Contents
The SUMIF function in Google Sheets is a useful tool for calculating the sum of a specific range of cells that meet certain criteria. It allows users to specify certain conditions and only add up the values that match those conditions. When working with multiple columns of data, the SUMIF function can be used to sum values from one column based on criteria in another column. This is done by including both columns in the function’s formula, with the criteria in one column and the values to be summed in the other. By using this function, users can efficiently calculate the total of specific data points in their spreadsheet, making data analysis and reporting more accurate and efficient.
Google Sheets: Use SUMIF with Multiple Columns
The SUMIFS() function in Google Sheets can be used to sum values that meet criteria in multiple columns.
This function uses the following syntax:
SUMIFS(sum_range, criteria_range1, criterion1, criteria_range2, criterion2, …)
where:
- sum_range: The range of cells to sum.
- criteria_range1: The first range of cells to look at.
- criterion1: The criterion to look for in the first range of cells.
The following example shows how to use this function in practice.
Example 1: Using SUMIFS with Character Columns in Google Sheets
Suppose we have the following dataset that shows information for various basketball players:
We can use the following SUMIFS() function to sum the points scored by players who are on the Spurs and have a Guard position.
The total points scored by players who are on the Spurs and have a Guard position is 44.
Example 2: Using SUMIFS with Character & Numeric Columns in Google Sheets
Once again suppose we have the following dataset that shows information for various basketball players:
We can use the following SUMIFS() function to sum the points scored by players who are on the Spurs and had more than 5 assists:
Specifically, we can see that three players met this criteria: Player 1, Player 2, and Player 4.
Combined, they have a total of 31 + 19 + 20 = 70 points.
Cite this article
stats writer (2024). How can I use the SUMIF function in Google Sheets with multiple columns?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-in-google-sheets-with-multiple-columns/
stats writer. "How can I use the SUMIF function in Google Sheets with multiple columns?." PSYCHOLOGICAL SCALES, 15 May. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-in-google-sheets-with-multiple-columns/.
stats writer. "How can I use the SUMIF function in Google Sheets with multiple columns?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-in-google-sheets-with-multiple-columns/.
stats writer (2024) 'How can I use the SUMIF function in Google Sheets with multiple columns?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-sumif-function-in-google-sheets-with-multiple-columns/.
[1] stats writer, "How can I use the SUMIF function in Google Sheets with multiple columns?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, May, 2024.
stats writer. How can I use the SUMIF function in Google Sheets with multiple columns?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.