3 tutorials tagged “countifs”.
COUNTIF, COUNTIFS or SUMPRODUCT? A decision table plus tested examples for AND, OR, case-sensitive, row-by-row and month counts, and the edge cases that give wrong totals.
SUMIFS returns 0 when you give one column two criteria. Sum North OR West with an array constant, a criteria list, FILTER or SUMPRODUCT, without double counting.
Count checked checkboxes in Google Sheets with COUNTIF, count per row or column with BYROW/BYCOL, count by owner or date with COUNTIFS, and show a % progress bar.