COUNTIFS Google Sheet Formula

Generate Google Sheet COUNTIFS Formulas in seconds

Try Formula Generator View Examples

Interactive Formula Generator

Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Upgrade to Sheet Alchemy Pro

Get advanced formulas, batch processing, and priority support

Upgrade Now

Input

Result

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Pro Features Available

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Advanced Formulas

Complex array formulas and dynamic ranges

Batch Processing

Generate multiple formulas at once

Unlimited History

Save and organize all your formulas

COUNTIFS Formula Syntax

=COUNTIFS(A1:A5, ">10", B1:B5, "<20")

Example Use Case

Counting cells meeting multiple conditions for detailed analysis

Understanding the COUNTIFS Formula

The COUNTIFS function in Excel counts cells meeting multiple criteria, expanding COUNTIF’s scope. It’s perfect for complex tallies—like counting sales within a range and category.

COUNTIFS(A1:A5, ">10", B1:B5, "<20") counts where A1:A5 > 10 and B1:B5 < 20. It uses pairs of ranges and criteria, offering a robust way to filter and count across multiple dimensions.

Why Use COUNTIFS?

COUNTIFS handles multi-condition counts—think items by type and value. Its precision and flexibility make it a data analyst’s ally for detailed, criteria-driven tallies.

Example with Sample Data

Data, Criteria	Formula	Result
5,15,25; 8,12,30; >10, <20	=COUNTIFS(A1:A3, ">10", B1:B3, "<20")	1
10,20; 5,15; >10, =15	=COUNTIFS(A1:A2, ">10", B1:B2, 15)	1
1,2,3; 'a','b','a'; =2, 'b'	=COUNTIFS(A1:A3, 2, B1:B3, "b")	1

COUNTIFS narrows counts: >10 and <20 is 1. It’s a multi-filter tallier.