Current progress:
={QUERY(A2:C,"select C,count(A) where A matches 'C|D|E|F|G|H|I|J|K' and A is not null group by C label count(A)''", 0),QUERY(A2:C,"select count(B) where B matches 'F|G|H|I|J|K' and B is not null group by C label count(B)''", 0)}
As we have discussed / tested on your sample sheet. This should work as close as possible to the data that you would want to filter/display.
Answer from Century Tuna on Stack OverflowInfoInspired
infoinspired.com › home › google docs › spreadsheet › countifs with multiple criteria in same range in google sheets
COUNTIFS with Multiple Criteria in Same Range in Google Sheets
2 weeks ago - If you want an explanation of this formula, please let me know. ... =COUNTIFS(Sheet1!$AK:$AK,$A23,Sheet1!$AJ:$AJ,"NO",Sheet1!$S:$S,"To be Scheduled Later - Customer","To be Scheduled Later - Rupeek") ... I guess there are multiple conditions to be evaluated in column S.
Top answer 1 of 3
1
Current progress:
={QUERY(A2:C,"select C,count(A) where A matches 'C|D|E|F|G|H|I|J|K' and A is not null group by C label count(A)''", 0),QUERY(A2:C,"select count(B) where B matches 'F|G|H|I|J|K' and B is not null group by C label count(B)''", 0)}
As we have discussed / tested on your sample sheet. This should work as close as possible to the data that you would want to filter/display.
2 of 3
0
A 2-formula solution was found to work as well. Answer is in the same spreadsheet linked above in Sheet2. It should prevent the first formula from not working should someone need a different one.
J2 - =QUERY(A2:C,"select C,count(A) where A matches 'C|D|E|F|G|H|I|J|K' group by C label count(A)''", 0)
L2 - =ArrayFormula(IFNA(vlookup(J2:J,QUERY(A2:C,"select C,count(B) where B matches 'F|G|H|I|J|K' group by C label count(B)''", 0),2,0)))
Using COUNTIF with multiple criteria.
Some functions don’t work with ARRAYFORMULA() let’s try MAP() =SUM(MAP(Master!B2:B100, Master!C2:C100, LAMBDA(t,r,N(AND(t=“Instrument”,r=“Pass”))))) More on reddit.com
17
4
May 2, 2024Using countif to count multiple criteria in a single cell - 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
google sheets - Countif Multiple Criteria from within same column & Criteria from other columns - Web Applications Stack Exchange
I would like to Count Multiple ... piece of criteria from 2 other columns in one tab into a count on a separate tab of the same workbook in google sheets. I am using this to track progress in a project. I have hacked together a formula that isn't working correctly: =((COUNTIFS(CCSS,"Number ... More on webapps.stackexchange.com
google sheets - COUNTIFS for Single Column Range but using Multiple Criteria - Web Applications Stack Exchange
I have a google sheet of 25k plus telephone records. The sheet has the phone numbers broken down so I have a single column (Column L) that has all the area codes dialed. I am trying to search that More on webapps.stackexchange.com
How do I use COUNTIFS to count cells with multiple criteria in Google Sheets?
COUNTIFS counts cells meeting multiple criteria: COUNTIFS(range1, criterion1, range2, criterion2, ...). Example: COUNTIFS(A1:A10, ">10", B1:B10, "<>0") counts cells >10 in A1 and not 0 in B1.
owox.com
owox.com › blog › articles › google sheets tips › how to master countif and countifs in google sheets
How to Master COUNTIF and COUNTIFS in Google Sheets
What are some best practices for using COUNTIF and COUNTIFS in Google Sheets?
Consistent Criteria Format: Ensure criteria are consistent (">10" instead of "> 10"). Range Size Consistency: Use ranges of equal size in COUNTIFS to avoid errors. Named Ranges: Utilize named ranges for clarity (=COUNTIF(Apples, ">10")). Regular Testing: Test formulas with sample data to verify accuracy.
owox.com
owox.com › blog › articles › google sheets tips › how to master countif and countifs in google sheets
How to Master COUNTIF and COUNTIFS in Google Sheets
What are some common errors when using COUNTIF and COUNTIFS in Google Sheets, and how can I fix them?
Common errors include mismatched criteria syntax or range sizes. Ensure criteria are correctly formatted (">10" instead of "> 10") and ranges are of equal size. Use COUNTIFS for multiple criteria and check cell formats.
owox.com
owox.com › blog › articles › google sheets tips › how to master countif and countifs in google sheets
How to Master COUNTIF and COUNTIFS in Google Sheets
05:59
How to Use the COUNTIFS Function in Google Sheets (Multiple Criteria) ...
02:06
Quick Google Sheets COUNTIFS Function Guide - YouTube
00:50
COUNTIF with multiple criteria from same column - YouTube
Google Sheets COUNTIFS Tutorial | Multiple Criteria
05:00
How to use COUNTIFS in Google Sheets | COUNTIF Multiple Criteria ...
06:34
0405 Multiple Criteria with CountIFs, SumIFs & AverageIFs - YouTube
Google Support
support.google.com › docs › thread › 198086660 › how-to-set-up-countifs-with-multiple-criteria
How to set up COUNTIFS with multiple criteria. - Google Docs Editors Community
January 19, 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
Coupler.io Blog
blog.coupler.io › home › when to use countif or countifs in google sheets: real-life formula examples
COUNTIF vs. COUNTIFS in Google Sheets | Coupler.io Blog
August 5, 2025 - Let’s say you need to check multiple criteria in the same data range. For example, you want to count the values in the F column of the All orders sheet (data_range) that contain exact “Mark Oliver” (criterion#1) and the values that contain “Olivia Jensen” (criterion#2). You might have thought about the following: =COUNTIFS(‘All orders’!F:F,”Mark Oliver”,’All orders’!F:F,”Olivia Jensen”)
Reddit
reddit.com › r/sheets › using countif with multiple criteria.
r/sheets on Reddit: Using COUNTIF with multiple criteria.
May 2, 2024 -
Hello, I am attempting to count the number of "Passes" but only depending on what they passed. For example, I need to count "Pass" but only if it was a pass for "Test A". So one column lists what they were working on and the other lists their results. The general idea would be along the lines of "If X1:X100 = "Test A", then countif Y1:Y100 "Pass" for each cell that is = "Test A". I hope I articulated this effectively. Thanks.
Top answer 1 of 3
3
Some functions don’t work with ARRAYFORMULA() let’s try MAP() =SUM(MAP(Master!B2:B100, Master!C2:C100, LAMBDA(t,r,N(AND(t=“Instrument”,r=“Pass”)))))
2 of 3
2
I'll do this as its own thread -- but why not use =COUNTIFS( X2:X,"Instrument", Y2:Y,"Pass") If you have multiple types -- e.g. Instrument, Test A, Test B, etc =QUERY( {X2:Y}, "select Col1, Count(Col1) where Col2 = 'Pass' group by Col1 label Col1 'Type', Count(Col1) 'Total'") That will run totals for everything in one go. I can break either of these down if you're going to use them
Google Support
support.google.com › docs › answer › 3256550
COUNTIFS - Google Docs Editors Help
Returns the count of a range depending on multiple criteria. ... criteria_range2, criterion2... - [ OPTIONAL ] - Additional ranges and criteria to check; repeatable. Any additional ranges must contain the same number of rows and columns as criteria_range1. COUNTIF: Returns a conditional count across a range.
Google Support
support.google.com › docs › thread › 182494263 › using-countif-to-count-multiple-criteria-in-a-single-cell
Using countif to count multiple criteria in a single cell - Google Docs Editors Community
October 5, 2022 - 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
Owox
owox.com › blog › articles › google sheets tips › how to master countif and countifs in google sheets
How to Master COUNTIF and COUNTIFS in Google Sheets
June 1, 2026 - Thus, the formula returns 1 counting the number of distinct Sales Rep roles with sales between $200 and $400. This method is helpful for filtering and counting specific data based on multiple criteria within the same or different columns. You can use the COUNTIFS function across different sheets in Google Sheets to count data that meets certain conditions.
Ben Collins
benlcollins.com › home › google sheets countifs function
Google Sheets COUNTIFS Function -
February 25, 2022 - =COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) The COUNTIFS function takes a minimum of two arguments but can take more. ... The range is the data that you want to count across.
Stack Exchange
webapps.stackexchange.com › questions › 158339 › countif-multiple-criteria-from-within-same-column-criteria-from-other-columns
google sheets - Countif Multiple Criteria from within same column & Criteria from other columns - Web Applications Stack Exchange
August 11, 2021 - I would like to Count Multiple Criteria from one column in addition to a single piece of criteria from 2 other columns in one tab into a count on a separate tab of the same workbook in google sheets. I am using this to track progress in a project. I have hacked together a formula that isn't working correctly: =((COUNTIFS(CCSS,"Number & Operations in Base Ten",Grade,{"K","1","2"},GoalStatus,{"Assigned to Writer","Goal Ready for Quality Review","Goal Quality Review Complete","Goal Ready for Copy Edit","Copy Edit Complete"})))
Ablebits
ablebits.com › ablebits blog › google sheets tips › google sheets functions › google spreadsheet countif function with formula examples
Google Spreadsheet COUNTIF function with formula examples
You'll see that if you enter the same into the ArrayFormula: ... Then the formula takes this TRUE/FALSE result and turns it into 1/0 numbers with the help of the double unary operator (--). This lets SUM do the rest — total the number of when E is greater than F. Sometimes it's necessary to count the number of values that answer at least one of the mentioned conditions (OR logic) or multiple criteria at once (AND logic). Based on that, you can use either a few COUNTIF functions in a single cell at a time or the alternate COUNTIFS function.
Published: August 16, 2021
Views: 45
Stack Exchange
webapps.stackexchange.com › questions › 166606 › countifs-for-single-column-range-but-using-multiple-criteria
google sheets - COUNTIFS for Single Column Range but using Multiple Criteria - Web Applications Stack Exchange
September 13, 2022 - And this": =SUM(COUNTIFS(L2:L25676,{"239","305","321","324","352","386","407","448","561","645","656","689","727","728","754","772","786","813","850","863","904","941","954"}))
Spreadsheet Point
spreadsheetpoint.com › home › formula posts › how to use the countifs google sheets function
How to Use the COUNTIFS Google Sheets Function
February 16, 2024 - If we want to find the number of items worth less than $600 sold Online, we can use the following formula: =COUNTIFS(Sheet1!E2:E22,"<600",Sheet1!C2:C22,"Online") We don’t really need to put in the sheet name and range manually, though. You can just select the needed columns directly from the other sheet. In this case, we want to count the criteria in columns C and E.
Stack Overflow
stackoverflow.com › questions › 72612924 › google-sheets-countif-with-multiple-criteria
Google Sheets Countif with multiple criteria - Stack Overflow
In a Google Sheet am trying to ... ie in how many columns do I have "R" and "Future". My current formula is =countifs(M11:BM11,"R",M$4:BM$4,"Future")...
Softr
softr.io › home › blog › 100 google sheets formulas that actually work: a cheat sheet
100 Google Sheets formulas: The complete list
July 23, 2026 - COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...]) Counts cells that satisfy multiple conditions across one or more ranges simultaneously, extending COUNTIF beyond a single criterion.
OfficeWheel
officewheel.com › home › google sheets › countif multiple criteria in google sheets (3 ways)
COUNTIF Multiple Criteria in Google Sheets (3 Ways) - OfficeWheel
January 10, 2022 - We will again apply the COUNTIFS equivalent formula (=COUNTIFS(E3:E12,">"&100,C3:C12,"North") in a SUMPRODUCT version: ... We hope that we were able to make to grasp the fundamentals and the different processes through which you can COUNTIF ...
ExcelMojo
excelmojo.com › home › google sheets › google sheets logical functions › countif with multiple criteria in google sheets
COUNTIF With Multiple Criteria In Google Sheets - How to Use?
March 11, 2025 - For example, consider the below ... with, select the cell A8 and insert the COUNTIF function in Google sheets formula, =COUNTIF(A2:A7,10)....
Layer
golayer.io › home › countif & countifs in google sheets: formula & examples
COUNTIF & COUNTIFS in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - You have a variety of examples with step-by-step instructions using different types of conditions, such as counting non-blank cells, cells containing partial or specific text, cells with values greater than or equal to a particular value, and cells with values within a range. Additionally, you will learn how to use the COUNTIFS function to count values based on multiple criteria. Let’s review the syntax for COUNTIF and COUNTIFS before using them. Google Sheets’ COUNTIF function has two required parameters.
The Bricks
thebricks.com › home › resources › how to count multiple criteria in google sheets
How to Count Multiple Criteria in Google Sheets - Bricks
February 20, 2025 - Your formula can then be written as `=COUNTIFS(Salespersons, "Elena", ...)` which is much cleaner. Watch for Hidden Spaces: A common source of errors is extra spaces in your data (e.g., "Elena " will not match "Elena"). Use the `TRIM` function ...