COUNT & counting patterns
Count cells by every condition — COUNT, COUNTA, COUNTBLANK, distinct counts, conditional counts, counts within ranges, and overlap counts.
3 pages · 3 how-to
How-to guides
How to count how many of a weekday are in a month
Count the number of Mondays, Fridays, or any specific weekday occurring within a given month using SUMPRODUCT and WEEKDAY.
How to build a frequency distribution
Build a frequency distribution in Excel or Google Sheets using FREQUENCY — count how many values fall in each bin with one array formula, no COUNTIF loop required.
How to count overlapping date ranges
Count overlapping date ranges in Excel or Google Sheets with SUMPRODUCT — detect how many date intervals share at least one day with a reference range, no VBA required.