Excel Study · Module 4: Counting & summing with conditions
Class 31COUNTIFS: two conditions
Intermediate1:43 videoFree
COUNTIF counts with one condition. COUNTIFS counts the rows where every condition is true at once: how many orders came from North in January?
Try this AI prompt
Works in ChatGPT, Gemini, Copilot or Claude.
In Excel, A2:A9 has regions and B2:B9 has months (Jan or Feb). Write a formula for F4 that counts the orders where the region is North and the month is Feb.
The answer that works
✓ checked in Excel=COUNTIFS(A2:A9,"North",B2:B9,"Feb")
AI can get Excel wrong. Paste its answer into Excel and test it before you trust it.