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 Overflow 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)))
InfoInspired
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 - However, sometimes conditions need to be tested in the same column along with conditions in other columns. The following syntax clearly specifies “criterion1”, “criterion2” in separate ranges, not “criterion1”, “criterion2”, … in the same range (criteria_range1): COUNTIFS(criteria_range1, criterion1, [criteria_range2, …], [criterion2, …]) This tutorial will guide you on the proper way to use multiple criteria in the same range in COUNTIFS in Google Sheets.
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 - 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
google sheets - COUNTIF with more than 3 criteria or use different formula? - Stack Overflow
I'm trying to get a count based on a specific entry in one column AND add the choice made from a separate column in my google sheets. Should I use a different formula than COUNTIF since I have multiple entries to count? More on stackoverflow.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 ...
08:16
Using the COUNTIFS Function in Google Sheets - 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
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
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 - Unfortunately, this won’t do ... criteria in the same column range, you need to use ARRAYFORMULA + SUM + COUNTIFS and place your criteria in the curly braces as follows:...
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 - 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.
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 - If we want to use multiple criteria in the same column with COUNTIFS, we have to make use of the OR logic and array values. Array values are denoted to be enclosed in curly braces {}. Our idea is simple for our example.
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 - So our COUNTIFS formula in Google Sheets would be: =COUNTIFS(B2:B22,"Baby Food",C2:C22,"Online",D2:D22,"<1/1/2015") ... Let us take another example. Say we want to find out how many office supply items worth more than $100 were sold offline. Again, let’s break down our requirements. We want to count the items where: ... Now let us look at a special case where we want to count cells with different conditions but from the same column.
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 › 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"}))
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.
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
Google Support
support.google.com › docs › thread › 193669607 › countifs-but-if-it-meets-any-of-the-multiple-criteria
Countifs but if it meets any of the multiple criteria - Google Docs Editors Community
December 20, 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
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 was trying to have the following happen: COUNTIF Criteria CCSS (Column AD) is "Number & Operations in Base Ten" AND Grade Criteria (Column E) is K, 1, OR 2 AND any of the following criteria are found in the GOALStatus Criteria (column B) {"Assigned to Writer","Goal Ready for Quality Review","Goal Quality Review Complete","Goal Ready for Copy Edit","Copy Edit Complete"}.
Google Support
support.google.com › docs › answer › 3093480
COUNTIF - Google Docs Editors Help
COUNTIF(table_name!score, “>90”) COUNTIF(criteria_column, criterion) criteria_column: The data column that is tested against `criterion`. criterion: The pattern or test to apply to `column`. Tip: Counting unique rows across multiple columns is not supported ·
Sheets Bootcamp
sheetsbootcamp.com › home › if statements › countif and countifs in google sheets
COUNTIF and COUNTIFS in Google Sheets | Sheets Bootcamp
February 26, 2026 - How do I count cells that contain specific text in Google Sheets? Use COUNTIF with a wildcard pattern. For example, =COUNTIF(D2:D11, "*ears*") counts every cell in D2:D11 that contains the word ears anywhere in the text.
Layer
golayer.io › home › countif & countifs in google sheets: formula & examples
COUNTIF & COUNTIFS in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - COUNTIF & COUNTIFS in Google Sheets: Formula & Examples – COUNTIFS Result · You can also use COUNTIFS to count the cells with values within a specified range by applying different criteria to the same range. For example, sales amounts above $600 but below $1000. ... COUNTIF and COUNTIFS are very useful functions. You can count cells based on their contents by specifying a single criterion or multiple criteria.