Cellgrids Cellgrids
Home › Excel formulas › Statistical › Two COUNTIFs multiplied (AND workaround)

Two COUNTIFs multiplied (AND workaround) Function in Excel: Syntax, Examples and Free Practice

By Rinkesh Shah, founder of Cellgrids.

Two COUNTIFs multiplied (AND workaround) is an Excel Statistical function. COUNTIFS natively supports AND logic across multiple ranges in one formula (the correct, simpler alternative to nesting COUNTIF calls).

Two COUNTIFs multiplied (AND workaround) syntax

=COUNTIFS(range1, "Value A", range2, "Value B")

Arguments

When to use Two COUNTIFs multiplied (AND workaround)

Counting orders that are BOTH 'High Priority' AND 'Overdue' at the same time.

Practice Two COUNTIFs multiplied (AND workaround) online, free

Open the live Excel-style spreadsheet and try Two COUNTIFs multiplied (AND workaround) yourself. No Excel install or sign-up needed to start.

Practice Two COUNTIFs multiplied (AND workaround) now →

More Statistical functions

Frequently asked questions

What does the Two COUNTIFs multiplied (AND workaround) function do in Excel?

COUNTIFS natively supports AND logic across multiple ranges in one formula (the correct, simpler alternative to nesting COUNTIF calls).

What is the syntax of Two COUNTIFs multiplied (AND workaround) in Excel?

The syntax is =COUNTIFS(range1, "Value A", range2, "Value B"). range1: First range; range2: Second range.

Where can I practice Two COUNTIFs multiplied (AND workaround) online for free?

Open the free live spreadsheet on Cellgrids and try Two COUNTIFs multiplied (AND workaround) yourself. No Excel install is needed and you can start without signing up.

All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts