A typical report: how many orders, how many are paid, what a particular customer has spent.
COUNTA(range) | number of non-empty cells (numbers and text) |
COUNT(range) | number of cells containing numbers |
COUNTIF(range, criteria) | how many cells meet the condition |
SUMIF(range, criteria, sum_range) | sum by one condition |
SUMIFS(sum_range, range1, criteria1, …) | sum by several conditions — the sum range comes first |
A criterion is text or a number ("Paid", 5) or a comparison in quotes: ">1000", "<>Cancelled". An asterisk matches any characters: "Smi*".
Another use of COUNTIF is finding values missing from another list: =COUNTIF(List_B, A2)=0.