COUNTIF()

Description

Returns a conditional count across a range.

How To Use in Sheets

COUNTIF(range, criterion)

External Links

COUNTING FORMULAS

Google Docs Help

8Better Sheets Tutorials

1

FREE

3 Ways to Count in Google Sheets

Make Color Changing Progress Bars - Make Progress Bars with Sparkline: Part 4

Creating A Dark Mode Theme | Announcing Dark Habits

Intermediate Most Popular

Build a habit tracker in dark mode. Learn how to use emojis and checkboxes effectively.

Ken Asks: How can I count true and false? Answer: w/ CountIF()

Deep Inside Dark Habits Google Script

Tagging Titles, Create a Comma Separated List of Tags

Create categories

Discover Duplicates Misspelt

Search and find duplicates that are spelled differently.

Zakir Asks: Find First Car in a Row

Find the first value in a row.