Google Support
support.google.com › docs › answer › 3093480
COUNTIF - Google Docs Editors Help
Google Sheets · Use functions and formulas · COUNTIF · Returns a conditional count across a range. For this same video with audio descriptions: COUNTIF function · To get an example spreadsheet and follow along with the video, click 'Make a copy' below. Make a copy ·
Published: November 18, 2020
Views: 221K
W3Schools
w3schools.com › googlesheets › google_sheets_countifs.php
Google Sheets COUNTIFS Function
GS Sort GS Sort Sheet GS Sort By ... function is a premade function in Google Sheets, which counts cells in a range based on one or more true or false condition....
Using countif to determine a specific text result
You should use =COUNTIF(B37:B39, "*Avenger*Iron Man Red*") in order to get a match for the "Avenger Iron Man Red" since that exact phrase isn't part of those three test lines. More on reddit.com
9
0
June 13, 2024Help with COUNTIF Function
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns. More on reddit.com
12
1
March 17, 2024Google sheets COUNTIF containing a cell reference in the criterion - Stack Overflow
Skip to main content · About · Products · Stack Internal · Stack Internal Implement a knowledge platform layer to power your enterprise and AI tools · Stack Data Licensing Get access to top-class technical expertise with trusted & attributed content · Stack Ads Connect your brand to the ... More on stackoverflow.com
wildcard - Google Spreadsheet, Count IF contains a string - Stack Overflow
I have a column like this: What devices will you be using? iPad Kindle & iPad No Tablet iPad iPad & Windows How do I count the amount of people that said iPad? This formula does work for 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
How to Use The COUNTIF Google Sheets Function - 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
How to Use The COUNTIF Google Sheets Function - 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
How to Use The COUNTIF Google Sheets Function - Coefficient
01:00
How to Use the COUNTIF Function in Google Sheets - YouTube
02:06
Quick Google Sheets COUNTIFS Function Guide - YouTube
06:03
Using the COUNTIF Function in Google Sheets - YouTube
05:59
How to Use the COUNTIFS Function in Google Sheets (Multiple Criteria) ...
08:16
Using the COUNTIFS Function in Google Sheets - YouTube
00:49
Google Sheets COUNTIF Function Made SUPER Easy in 2 Minutes! - YouTube
Coefficient
coefficient.io › home
How to Use The COUNTIF Google Sheets Function - Coefficient
September 2, 2025 - For example, if your formula is =COUNTIF(A3:A23,”A?r”), using the formula will match any string with three characters where the first and last characters are “A” and “r”. The tilde (~) allows you to search for an star or question mark instead of using them as wildcards. For example, =COUNTIF(E2:E23,”No~*”) counts all the cells containing No*, and =COUNTIF(E2:E23,”No~?”) counts all cells with No?. Let’s set up our sample dataset in Google Sheets so we can show off some examples of COUNTIF.
Reddit
reddit.com › r/googlesheets › using countif to determine a specific text result
r/googlesheets on Reddit: Using countif to determine a specific text result
June 13, 2024 -
Im stuck at one point. I'm trying to use countif formula to determine how many times a word of a string of words appear but sometimes there are two entries in a single cell and I have separated them by a slash. The countif formula doesn't seem to capture it. I'll show an example attached to this.
Avenger Iron Man comes two times and Avenger Iron Man Red comes two times but somehow the countif doesn't capture the word after the slash.
(for your information this is just a basic example. My actual spreadsheet is massive and has a lot of entries separated by slash. 99 percent of the time I can filter by using a unique word. But when similar words come then it just fails). Any help would be appreciated.
Top answer 1 of 5
2
You should use =COUNTIF(B37:B39, "*Avenger*Iron Man Red*") in order to get a match for the "Avenger Iron Man Red" since that exact phrase isn't part of those three test lines.
2 of 5
2
The function in your screenshot is counting correctly as the list has 3 cells with the phrase “Avenger Iron Man”. What was the desired result from this function?
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 - Count the values that meet all the following criteria: 1. Values in the G column of the All orders sheet (data_range#1) that are greater or equal to 10 (criterion#1). 2. Values in the F column of the All orders sheet (data_range#2) that contain “Mark Oliver” text exactly (criterion#2). 3. Values in the I column of the All orders sheet (data_range#3) that are less than 50 (criterion#3). In this tab, you can check out the formula example and compare it to separate COUNTIF formulas based on the mentioned criteria.
Sheetgo
sheetgo.com › home › countif greater than 0 google sheets
Countif greater than 0 Google Sheets - Sheetgo
December 17, 2025 - At its core, countif is super simple: it counts every cell that meets a condition.
Rows
rows.com › blog › post › countif-formula-in-google-sheets
How to Use the COUNTIF Google Sheets Function in 2025
August 19, 2024 - The COUNTIF function in Google Sheets allows you to count the number of cells in a range that meets a specified criterion. ... Open your Google Sheet and input the formula into a cell. Replacing with your text criterion.
Ben Collins
benlcollins.com › home › google sheets countif function
Google Sheets COUNTIF Function
March 18, 2022 - This formula counts how many times “John” is found in the range: ... The range is the data that you want to count across. The criterion is the test you want to apply. If you want to apply multiple tests for counting, then you need to use the COUNTIFS function. Think of the COUNTIF function as the love child of the IF function and COUNT function. It’s part of the Math family of functions in Google Sheets.
Layer
golayer.io › home › countif & countifs in google sheets: formula & examples
COUNTIF & COUNTIFS in Google Sheets: Formula & Examples | Layer Blog
July 17, 2024 - In Google Sheets, you can use the COUNTIFS function to count cells based on multiple criteria, and each criterion can be applied to a different range. For example, you can count the sales of a specific product with values greater than a particular amount and values within a specific range. Let’s find the number of sales of productA for an amount greater than $500. 1. In an empty cell, type in the COUNTIFS formula.
Reddit
reddit.com › r/googlesheets › help with countif function
r/googlesheets on Reddit: Help with COUNTIF Function
March 17, 2024 -
Hello all. I have a spreadsheet that I'm using to track recipes in a game that I'm playing. I have checkboxes in column A to track whether or not I have already made the recipe. The ingredients for each recipe are in columns E-I. Off to the side, I have listed every possible ingredient, and I would like to use the COUNTIF function to track how many of each ingredient I would need to make all of the remaining recipes. I cannot for the life of me figure out the best way to have it only pull from rows where the checkbox value is FALSE. Should I be using COUNTIFS? I've dabbled in Google Sheets functions before, but I am by no means a pro. Any help is appreciated.
Edit:
Here's the spreadsheet (only the first sheet matters, the other sheet is a work in progress for the DLC): https://docs.google.com/spreadsheets/d/1PHjt_mjd18MGHiMKyFS52exw3wp0QbAtSroCXfNYw5s/edit?usp=sharing
Top answer 1 of 4
1
Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide . You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you. I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
2 of 4
1
u/osrpokerchamp Yes, COUNTIFS. The formula will need to count if the row contains both the name of the ingredient and the FALSE checkbox. Assuming your list of ingredients is in column K, you could try: =COUNTIFS(A:A,FALSE,E:I,$K2) Reply with Solution verified if this answers your question, as required by the subreddit rules.
YouTube
youtube.com › watch
Countif Function in Google Sheets - YouTube
Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.
Published: November 23, 2016
Google Support
support.google.com › docs › answer › 3256550
COUNTIFS - Google Docs Editors Help
COUNTIF: Returns a conditional count across a range.
LiveFlow
liveflow.com › product-guides › how-to-use-countif-function-in-google-sheets
How to Use COUNTIF Function in Google Sheets | LiveFlow
For instance, if you want to count ... up the results from two separate COUNTIF formulas like “=COUNTIF(range C, criterion A)+COUNTIF(range C, criterion B)”....
Stack Overflow
stackoverflow.com › questions › 77055968 › google-sheets-countif-containing-a-cell-reference-in-the-criterion
Google sheets COUNTIF containing a cell reference in the criterion - Stack Overflow
Skip to main content · About · Products · Stack Internal · Stack Internal Implement a knowledge platform layer to power your enterprise and AI tools · Stack Data Licensing Get access to top-class technical expertise with trusted & attributed content · Stack Ads Connect your brand to the ...
Top answer 1 of 7
138
It will likely have been solved by now, but I ran accross this and figured to give my input
=COUNTIF(a2:a51;"*iPad*")
The important thing is that separating parameters in google docs is using a ; and not a ,
2 of 7
94
In case someone is still looking for the answer, this worked for me:
=COUNTIF(A2:A51, "*" & B1 & "*")
B1 containing the iPad string.
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
Learn more about these in the following articles: COUNTA for Google Sheets Concatenation operator: & ... For example, first tab name PROGRAM PENDIDIKAN (PROGRAM) and second tab name BANTUAN PERSEKOLAHAN (PENDIDIKAN). So, in each tab, there is column for various state name. So, i would like to know total count for each state added up from both tab [PROGRAM PENDIDIKAN (PROGRAM) & BANTUAN PERSEKOLAHAN (PENDIDIKAN)] My formula: =COUNTIF('PROGRAM PENDIDIKAN (PROGRAM)'!F2:F72,"JOHOR" + COUNTIF('BANTUAN PERSEKOLAHAN (PENDIDIKAN)'!F2:F31,"JOHOR"))
Published: August 16, 2021
Views: 45
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 - The everyday counting, rounding, and summing formulas most spreadsheets run on. ... Counts how many cells in a range satisfy a single condition, whether that's an exact match, a text string, or a comparison. Criteria support operators like ">" or "<", so you can tally cells above or below a threshold without touching text criteria at all. ... Counts cells in A1:A10 greater than 5. COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
Sheetai
sheetai.app › blog › how-to-use-countif-in-google-sheets
How to Use COUNTIF in Google Sheets: A Comprehensive Guide
July 27, 2024 - After entering the formula, press Enter. Google Sheets will count the number of cells in the specified range that have sales greater than $500. If you have a list of responses and you want to count how many times a specific response appears, you can use COUNTIF.
Top answer 1 of 4
67
One option:
=COUNTIF(B:B; "Mammal") + COUNTIF(B:B; "Bird")
According to the documentation:
Notes
COUNTIF can only perform conditional counts with a single criterion. To use multiple criteria, use COUNTIFS or the database functions DCOUNT or DCOUNTA.
COUNTIFS: This function is only available in the new Google Sheets.
Example:
=DCOUNTA(B:B; 2; {"Type"; "Mammal"; "Bird"})
2 of 4
18
You can also use ArrayFormula around a SUM(COUNTIFS()) construct:
=ArrayFormula(SUM(COUNTIF(B:B,{"Mammal", "Bird"}))
Source: Google Docs Product Forum