Proper Usage of the SUMIFS function
Based on your formula, it seems that your usage of SUMIFS is incorrect.
The parameters of the SUMIFS function are:
SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Since you have not posted a sample set of data, I used the following sample data:
Here is the formula:
=SUMIFS(E5:E, B5:B, "Stuart Rowe", C5:C, "No")
The first parameter E5:E is the range of cells to be summed. The second parameter B5:B is the range to check against Stuart Rowe which is the first criterion and also the third parameter. The fourth parameter C5:C and fifth parameter No are additional ranges and criteria that will also be checked.
Reference:
- SUMIFS function
Google Support
support.google.com › docs › answer › 3238496
SUMIFS function - Google Docs Editors Help
Returns a conditional sum of a data column depending on multiple criteria. =SUMIFS(table_name!inventory, table_name!fruits, "Apple", table_name!price, ">5")
Reddit
reddit.com › r/googlesheets › sumifs with multiple criteria
r/googlesheets on Reddit: SUMIFs with Multiple Criteria
July 12, 2024 -
I'm creating a budget tracking sheet and I'm lost on how to add additional qualifiers to my SUMIF equation.
I'm breaking down the totals per person and what has been paid and not paid yet. I figured out how to total per person, but how do I add another qualifier for if the paid column is ticked? Any ideas? or perhaps suggestions on how to make this sheet more efficient? Im open to switching things up.
Im new to creating long and complicated equations. Any help is appreciated! :)
https://imgur.com/a/Wnn39qB
SUMIFS with multiple criteria in same row - Google Docs Editors Community
Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on More on support.google.com
SUMIFs with Multiple Criteria
It's in your title, actually—you just need to use SUMIFS() instead of SUMIF(). The adapted version of the formula shown in the screenshot would be =SUMIFS(E7:E,A7:A,"Both",F7:F,TRUE)+SUMIFS(E7:E,A7:A,"Person1",F7:F,TRUE) More on reddit.com
5
1
July 12, 2024SUMIFS with OR logic
can you just create a dummy variable in your original data outputting the result of whatever logic you have and then use that as the sole condition for your sumif? More on reddit.com
10
3
May 12, 2021Help with SUMIF/SUMIFS // Pulling data from another sheet with multiple criteria to display units sold and net sales.
=arrayformula(sumifs(Sunday!AA:AA,Sunday!P:P,"gold flora",Sunday!N:N,"cartridge",regexmatch(Sunday!O:O,"510 THREAD|READY TO USE"),true)) More on reddit.com
5
1
March 13, 202400:48
How to Use SUMIFS in Google Sheets (Multiple Conditions) - YouTube
07:04
Using the SUMIFS Function in Google Sheets - YouTube
05:57
SUMIFS Google Sheets | Multiple criteria on columns - YouTube
04:34
How to Use Sumif with Multiple Criteria in Google Sheets - YouTube
23:52
How to SUMIFS with Date Range & Multiple Criteria (Year to date, ...
Google Support
support.google.com › docs › thread › 232764969 › sumifs-with-multiple-criteria-in-same-row
SUMIFS with multiple criteria in same row - Google Docs Editors Community
August 30, 2023 - Skip to main content · Google Docs Editors Help · Sign in · Google Help · Help Center · Community · Google Docs Editors · Terms of Service · Submit feedback · Send feedback on
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › google sheets sumifs to sum cells with multiple and / or criteria
Google Sheets SUMIFS to sum cells with multiple AND / OR criteria
April 19, 2024 - The SUMIFS function is Google Sheets is designed to sum numbers with multiple conditions. Its arguments are as follows: SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2, criterion2, …])
Ben Collins
benlcollins.com › home › google sheets sumifs function
Google Sheets SUMIFS Function
March 9, 2022 - In other words, the SUMIFS in Google Sheets adds values to a total only when multiple conditions are met. Suppose we want to calculate the total for Large products in New York: The SUMIFS function to calculate the total for two conditions, Large ...
Sheetgo
sheetgo.com › home › sumifs with multiple criteria in google sheets
SUMIFS with multiple criteria in Google Sheets - Sheetgo
December 17, 2025 - This formula doesn’t make a good use of the function because it only includes one criteria. Let’s include parts of the previous formula to make the most of SUMIFS: =SUMIFS(C:C, A:A, “*Blox*”, E:E, “Dave Brown”, F:F, “Debit Card”) These examples illustrate the versatility of the SUMIFS function in Google Sheets, enabling users to perform comprehensive data analysis with multiple conditions and partial matches.
Coursera
coursera.org › coursera articles › data › data analytics › how to use sumif in google sheets
How to Use SUMIF in Google Sheets | Coursera
December 16, 2025 - Like SUMIF, the SUMIFS function also adds a range of values based on the criteria you define. However, you would use SUMIFS for a range with multiple criteria and SUMIF to evaluate the data based on one criterion.
Excel Insider
excelinsider.com › home › our blog › google sheets functions › how to use sumif with multiple criteria in google sheets
How to Use SUMIF with Multiple Criteria in Google Sheets - Excel Insider
June 28, 2025 - Replace hard coded criteria with cell references, like =SUMIFS(E2:E11, B2:B11, H2, D2:D11, I2), so the formula updates automatically when input values change. Use SUMPRODUCT to apply OR logic, combining multiple conditional sums. For example, sum where Region is East or West, and Product is Mouse. Mastering SUMIF and SUMIFS in Google Sheets allows you to efficiently analyze data based on specific conditions, whether it’s summing sales by product, filtering by region, or handling multiple criteria.
10XSheets
10xsheets.com › blog › sumif-google-sheets
How to Use SUMIF in Google Sheets (With Multiple Criteria) | 10XSheets
In this formula, the criteria for summation is taken from cell F2. It sums all values from the range B2:B where the corresponding value in the range A2:A matches the value in cell F2. These examples demonstrate the versatility of the SUMIF function and how it can be customized to meet specific requirements in your Google Sheets projects.
Ccac
web.acd.ccac.edu › ~ndowney › CIT140 › Excel › Formulas.pdf pdf
Excel Formulas Cheat Sheet Page 1 of 7 Basic Formulas Formula Structure
Excel Formulas Cheat Sheet · Page 4 of 7 · Statistical Formulas · Formula · Structure · Explanation · SUMIF · = SUMIF(range, criteria, [sum_range]) · SUMIF will return at total based on one criteria · · Range - Required. The range of cells that you want evaluated by criteria.
AWS
docs.aws.amazon.com › amazon quick › user guide › using amazon quick automations › using amazon quick automate › export and import automations
Export and import automations - Amazon Quick
You can use the import and export feature in Amazon Quick Automate to share and migrate automation versions across automation groups, AWS accounts, and AWS Regions.
LiveFlow
liveflow.com › product-guides › sumif-function-in-google-sheets
How to Use SUMIF Function in Google Sheets | LiveFlow
Yes, you can, but you need to use the “SUMIFS” function for multiple criteria instead of the “SUMIF” function we introduce on this page. Check the following page to learn about the SUMIFS formula: SUMIFS Function in Google Sheets: Explained
All In One
license.pmmc.gov.gh › home › newsreview › google sheets sumif with multiple criteria
Google Sheets Sumif With Multiple Criteria - All In One
March 12, 2026 - ... The SUMIFS function in Google Sheets is used to sum a range of cells based on multiple criteria. The syntax of the SUMIFS function is: SUMIFS(sum_range, criteria_range1, criterion1, [criteria_range2], [criterion2], …).
Business Insider
businessinsider.com › business insider › how to use the sumif function in google sheets to find a specific sum in your spreadsheet
How to use the SUMIF function in Google Sheets to find a specific sum in your spreadsheet
August 23, 2022 - For example, suppose you have a spreadsheet like this one, and you are interested in the sum of all the numbers that are 100 or higher. Type "=SUMIF" and press the Tab key. Google Sheet will automatically add the open parenthesis and wait for ...
Udemy
udemy.com › finance & accounting
Beginner to Pro in Excel: Financial Modeling and Valuation
1 month ago - Learn to use Excel's sum, sumif, and sumifs formulas to add values in a range by criteria, with examples like Italian teams' games and English teams' Champions League points.
DataCamp
datacamp.com › tutorial › sumifs
SUMIFS() Function in Excel: Sum Data with Multiple Criteria | DataCamp
March 4, 2025 - This formula first specifies the range of cells to sum (C2:C5) as the first argument. Then, it applies two conditions described above to the same range. The SUMIFS() function simultaneously evaluates each cell in the range against both criteria.
Ablebits
ablebits.com › ablebits blog › excel › sumif › excel: sumif multiple columns with one or more criteria
Excel: SUMIF multiple columns with one or more criteria
April 14, 2023 - Sheet2 is data sheet A:A= item code B:B=locations C:C= value · so if a1 and b1 matches with a:a and b:b then total to be resut. ... Hi! If I understand you correctly, to summarize values by multiple criteria, use the SUMIFS function. For more ...
8020sheets
8020sheets.com › home › how to use the sumif function in google sheets (with worksheet and examples)
How to use the SUMIF Function in Google Sheets (with Worksheet and Examples)
That is, we can conditionally sum cells only if they fall within a certain specified criteria (or within multiple criteria) such as ">cell reference" or if a certain cell reference matches a specified criteria such as "Pool Store" (we will use ...
Published: December 15, 2022
GeeksforGeeks
geeksforgeeks.org › excel › excel-interview-questions-and-answers
200 Excel Interview Questions & Answers: Beginner to Expert (2025 Updated) - GeeksforGeeks
July 20, 2026 - The CONCAT function combines text from multiple ranges into one string. For example, =CONCAT(A1:A5) concatenates all values in the range A1:A5. You can use Excel to manage inventory by creating a structured tracker with columns for item ID, product name, quantity in stock, reorder level, and supplier details. Employ Excel tables for easy sorting and filtering, formulas such as SUMIF or VLOOKUP for calculating totals and tracking movements, and conditional formatting to automatically highlight low-stock items in red.