3 tutorials tagged “countif”.
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.
Highlight values that appear in both columns in Google Sheets with a COUNTIF custom formula. Covers one column, both columns, same row, missing values, case and spaces.
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.