Google Support
support.google.com › docs › answer › 3093583
SUMIF - Google Docs Editors Help
=SUMIF(table_name!price, ">5", table_name!inventory)
W3Schools
w3schools.com › googlesheets › google_sheets_sumif.php
Google Sheets SUMIF Function
The SUMIF function is a premade function in Google Sheets, which calculates the sum of values in a range based on a true or false condition.
SUMIF not working as expected
formula syntax is off =SUMIF(range, criterion, [sum_range]) range - The range which is tested against criterion criterion- The pattern or test to apply to range sum_range - The range to be summed, if different from range More on reddit.com
12
2
July 28, 2024google sheets - Adding Multiple Conditions to a SUMIF - Stack Overflow
I'm confused with a Google Sheet that I have going. I am trying to add multiple conditions to one Sumif. I have one cell that is conditional to a name. (If this cell equals this name, and if this c... More on stackoverflow.com
Google Sheets: Summing SUMIF & IF
In your google doc, can you highlight where the formulas need to be? More on reddit.com
4
1
January 27, 2024regex - SUMIFS with OR criteria in Google Sheets - Stack Overflow
I want to add values in Column C with the conditions that Column B = 0, AND Column A = "a" OR "b" From what I've searched, this would work, but only in excel: =SUM(SUMIFS(C:C,B:... More on stackoverflow.com
Does Coefficient work with both Google Sheets and Excel?
Yes, Coefficient supports both Google Sheets and Microsoft Excel. You can install Coefficient from the Google Workspace Marketplace for Sheets or from Microsoft AppSource for Excel.
coefficient.io
coefficient.io › home
SUMIFS Google Sheets: Ultimate Guide - Coefficient
What is Coefficient's AI Sheets Assistant?
AI Sheets Assistant is Coefficient's AI-powered feature that helps you build formulas, create charts, generate pivot tables, and build entire dashboards using natural language commands in Google Sheets. Unlike generic AI assistants, it's context-aware and creates native Google Sheets objects that are live and editable. It understands your spreadsheet's layout and data structure to provide accurate, actionable results.
coefficient.io
coefficient.io › home
SUMIFS Google Sheets: Ultimate Guide - Coefficient
How does Coefficient's automated refresh work?
Coefficient allows you to schedule automatic data refreshes at intervals you choose: hourly (1, 2, 4, or 8 hours), daily, weekly, or monthly. Once scheduled, your spreadsheet data automatically updates from your connected systems without any manual work. You can also trigger manual refreshes anytime with an on-sheet button or through the sidebar.
coefficient.io
coefficient.io › home
SUMIFS Google Sheets: Ultimate Guide - Coefficient
Google Sheets: How to Use SUMIF (Sum by Category)
01:00
How to Use SUMIF in Google Sheets - YouTube
How to use the SUMIF Function in Google Sheets - YouTube
07:05
Using the SUMIF Function in Google Sheets - YouTube
00:42
How to Use SUMIF in Google Sheets (Conditional Sum) - YouTube
Google Support
support.google.com › docs › answer › 3238496
SUMIFS function - Google Docs Editors Help
SUMIFS(sum_column, criteria_column1, criterion1, criteria_column2, criterion2)
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 - You can use the SUMIF function in Google Sheets to add numbers across a range of cells if they meet the conditions or to summarize data in a category.
Coefficient
coefficient.io › home
SUMIFS Google Sheets: Ultimate Guide - Coefficient
September 2, 2025 - Now let’s use this real-life data set to learn how to use the SUMIFS function. Let’s say you want the total amount for a specific item with a certain subscription status, such as Active Basic plans. In theory, you could use an arrayformula that looks like this: =ARRAYFORMULA(SUMPRODUCT((A6:A14=”Basic”)*(C6:C14=”Active”)*(B6:B14))) While using an ARRAY formula gives your expected result, it can be needlessly complex. An easier method is to use the Google Sheets SUMIFS function.
Mailchimp
mailchimp.com › resources › sumif-google-sheets
Mastering SUMIF in Google Sheets | Mailchimp
For our example, let's say the cell range is D2:D10, and the date criteria exist in cells B2:B10. So, in this example, the formula=SUMIF(D2:10, "March", B2:B10), Google Sheets will sum only the values within C2:C10 when the cells in the range ...
W3Schools
w3schools.com › googlesheets › google_sheets_sumifs.php
Google Sheets SUMIFS Function
GS Sort GS Sort Sheet GS Sort By ... function is a premade function in Google Sheets, which calculates the sum of a range based on one or more true or false condition....
Sheetgo
sheetgo.com › home › sumifs with multiple criteria in google sheets
SUMIFS with multiple criteria in Google Sheets - Sheetgo
December 17, 2025 - This function is designed to add values in a range based on one or multiple criteria. For values to be included in the sum, all conditions must be met. Unlike SUMIF, SUMIFS can accommodate numerous conditions from different columns, making it ...
Sheetgo
sheetgo.com › home › how to sumif in google sheets
How to SUMIF in Google Sheets - Sheetgo
December 17, 2025 - The SUMIF function in Google Sheets allows you to sum values in a range based on specific criteria.
Layer
golayer.io › home › sumif & sumifs in google sheets: formula & examples
SUMIF & SUMIFS in Google Sheets: Formula & Examples | Layer Blog
September 23, 2024 - If you want to find the sum of values based on one or more conditions in Google Sheets, the SUMIF and SUMIFS functions come in handy. Here’s how to use…
LiveFlow
liveflow.com › product-guides › sumif-function-in-google-sheets
How to Use SUMIF Function in Google Sheets | LiveFlow
Summing the values in a range based ... function in Google Sheets is a powerful and versatile tool that is useful for calculating the sum of values in a range of cells based on a certain requirement....
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › sumif in google sheets with formula examples
SUMIF in Google Sheets with formula examples
April 17, 2024 - To put it differently, SUMIF(A1:A10, "apples", B1:B10) and SUMIF(A1:A10, "apples", B1:B100) will both sum values in the range B1:B10 because it is the same size as range (A1:A10). So, even if you mistakenly supply a wrong sum range, Google Sheets will still calculate your formula right, provided the top left cell of sum_range is correct.
Reddit
reddit.com › r/googlesheets › sumif not working as expected
r/googlesheets on Reddit: SUMIF not working as expected
July 28, 2024 -
Hey r/googlesheets
I'm trying to create a budget spreadsheet where I can sum up how much I've spent over a certain category. SUMIF seems to be the function I want to use for this, but it's not working as expected.
Here you can see my sheet so far, and my formula that I'm trying to use. I've got my input range of values in my 'E' column. I'm trying to sum up the amount of 'Social' here. I've used the value in the D5 column, to make sure that there is an exact match in the column for the value I'm searching for, and there's nothing like a case/cell format mismatch going on, and then searching for values in the 'D' column to sum over.
I've made sure that the format in both my SUMIF and values column is the same (currency), so I'm out of ideas now.
Thanks!
Top answer 1 of 3
1
formula syntax is off =SUMIF(range, criterion, [sum_range]) range - The range which is tested against criterion criterion- The pattern or test to apply to range sum_range - The range to be summed, if different from range
2 of 3
1
You need to switch your d range and e range. The range being summed is the third input not the first with 2 ranges.
GeeksforGeeks
geeksforgeeks.org › sumif-in-google-sheets-with-formula-examples
SUMIF in Google Sheets with formula examples - GeeksforGeeks
January 14, 2026 - Google sheets lets us sum values based on multiple criteria. Let's say we want to find the total number of books belonging to genre "Horror" or "Thriller", we can apply the multiple criteria formula: =SUMIF(C3:C18,"Horror",D3:D18)+SUMIF(C3:...
Better Sheets
bettersheets.co › formulas › sumif
SUMIF Google Sheets Formula: Conditional Sum + · Better Sheets
SUMIF in Google Sheets adds values when a condition is true. Syntax, examples, and video tutorials for conditional totals across one column or range.
Reddit
reddit.com › r/spreadsheets › google sheets: summing sumif & if
r/spreadsheets on Reddit: Google Sheets: Summing SUMIF & IF
January 27, 2024 -
Hi, I'm looking for a way to sum up with these conditions:
- add up all transactions under a category, e.g., Category 1
- add up all "General" transactions and then divide the sum by the number of categories, e.g., 4
The cell containing the formula will supposedly return the sum of the two conditions
I can't figure out the proper way to input/nest them though
Here's the link to a sample spreadsheet for better visualization
Appreciate your help!
Top answer 1 of 3
9
try:
=SUM(FILTER(C:C, B:B=0, REGEXMATCH(A:A, "a|b")))
2 of 3
8
@player0 has a top solution, but if you want to use sumifs(), then try:
=sumifs(C:C,B:B,0,A:A,"a")+sumifs(C:C,B:B,0,A:A,"b")
Or
=arrayformula(sumifs(C:C,B:B,0,regexreplace(A:A,"a|b","a"),"a"))
It can also be done with query():
=query({A:C},"select sum(Col3) where Col2=0 and Col1 matches 'a|b' label sum(Col3) '' ",0)
Arab Psychology
scales.arabpsychology.com › home › how to use sumif across multiple sheets in google sheets
How To Use SUMIF Across Multiple Sheets In Google Sheets
December 1, 2025 - For instance, if you are performing the calculation on Sheet2 but the data resides on Sheet1, your formula would look like: =SUMIF(Sheet1!Range_to_Check, "Your_Criteria", Sheet1!Range_to_Sum). This technique is vital for maintaining organized workbooks where raw data is kept separate from analytical summaries. Cross-sheet referencing is the foundational mechanism that allows complex workbooks in Google Sheets to function efficiently.
X
x.com › Kanbanchi › status › 1919336268090978718
Kanbanchi on X: "Master SUMIF in Google Sheets in under a minute! Learn how to add values based on conditions quickly and easily #GoogleSheets #ExcelTips #Productivity Watch here: https://t.co/KX7dZPXmn9" / X
May 5, 2025 - Master SUMIF in Google Sheets in under a minute! Learn how to add values based on conditions quickly and easily #GoogleSheets #ExcelTips #Productivity Watch here: https://t.co/KX7dZPXmn9