Table of Contents
The SUMIFS function in Google Sheets allows users to calculate the sum of values based on multiple criteria. This function requires the user to specify a range of cells to sum, as well as one or more criteria ranges and corresponding criteria values. The function then sums only the values that meet all of the specified criteria, providing a more precise and targeted calculation. This can be useful in situations where a user needs to filter and sum data based on specific conditions. By utilizing the SUMIFS function, users can efficiently and accurately calculate the sum of values in their Google Sheets spreadsheet.
SUMIFS function
Returns the sum of a range depending on multiple criteria.
Returns a conditional sum of a data column depending on multiple criteria.
Sample Usage
=SUMIFS(table_name!inventory, table_name!fruits, "Apple", table_name!price, ">5")
Syntax
SUMIFS(sum_column, criteria_column1, criterion1, criteria_column2, criterion2)
sum_column– The data column to sum.criteria_column1: The data column to check against criterion1.criterion1– The pattern or test to apply to criteria_column1.criteria_column2– Additional data columns to check.criterion2– Additional criteria to check.
Tip: Returning sum across multiple columns is not supported.
Sample Usage
SUMIFS(A1:A10, B1:B10, ">20")
SUMIFS(A1:A10, B1:B10, ">20", C1:C10, "<30")
SUMIFS(C1:C100, E1:E100, "Yes")
Syntax
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
sum_range– The range to be summed.criteria_range1– The range to check againstcriterion1.criterion1– The pattern or test to apply tocriteria_range1.criteria_range2, criterion2, ...– [ OPTIONAL ] – Additional ranges and criteria to check.
See Also
SUM: Returns the sum of a series of numbers and/or cells.
SUMIF: Returns a conditional sum across a range.
SUMSQ: Returns the sum of the squares of a series of numbers and/or cells.
SERIESSUM: Given parameters x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + … + aix(n+(i-1)m), where i is the number of entries in range `a`.
QUOTIENT: Returns one number divided by another, without the remainder.
PRODUCT: Returns the result of multiplying a series of numbers together.
MULTIPLY: Returns the product of two numbers. Equivalent to the `*` operator.
MINUS: Returns the difference of two numbers. Equivalent to the `-` operator.
DSUM: Returns the sum of values selected from a database table-like array or range using a SQL-like query.
DIVIDE: Returns one number divided by another. Equivalent to the `/` operator.
COUNTIF: Returns a conditional count across a range.
ADD: Returns the sum of two numbers. Equivalent to the `+` operator.
Cite this article
stats writer (2024). How can I use the SUMIFS function in Google Sheets to calculate the sum of values based on multiple criteria?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-google-sheets-to-calculate-the-sum-of-values-based-on-multiple-criteria/
stats writer. "How can I use the SUMIFS function in Google Sheets to calculate the sum of values based on multiple criteria?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-google-sheets-to-calculate-the-sum-of-values-based-on-multiple-criteria/.
stats writer. "How can I use the SUMIFS function in Google Sheets to calculate the sum of values based on multiple criteria?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-google-sheets-to-calculate-the-sum-of-values-based-on-multiple-criteria/.
stats writer (2024) 'How can I use the SUMIFS function in Google Sheets to calculate the sum of values based on multiple criteria?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-sumifs-function-in-google-sheets-to-calculate-the-sum-of-values-based-on-multiple-criteria/.
[1] stats writer, "How can I use the SUMIFS function in Google Sheets to calculate the sum of values based on multiple criteria?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the SUMIFS function in Google Sheets to calculate the sum of values based on multiple criteria?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.