Count & Sum
COUNTIF, COUNTIFS, SUMIF and SUMIFS in Google Sheets: several conditions, cells that only look blank, partial text matches and date ranges, all tested.
-
SUMIFS with Multiple Criteria in Google Sheets (AND, OR and the Array Trap)
SUMIFS adds up the rows that meet every condition you give it. That covers “this and that”. For “this or that” you need another approach, and the shortcut many guides…
-
Percentage of Total in Google Sheets (Rows, Categories and the $ That Matters)
A row’s percentage of the total is its value divided by the sum of all the values. In Google Sheets that’s one short formula, but two details decide whether it’s…
-
SUMIFS Between Two Dates in Google Sheets (and the Last Day It Misses)
To add up the values that fall between two dates, give SUMIFS two conditions on the date column: one for the start and one for the end. The formula is…
-
COUNTIF Not Blank in Google Sheets: Count Cells That Really Have Content
The usual answer to “count cells that are not blank” is =COUNTIF(range, “<>”) or COUNTA. Both work on a clean column. But a cell can look empty without being empty:…
-
COUNTIF with Multiple Criteria in Google Sheets (AND and OR, Tested)
COUNTIF takes one condition. To count rows that meet two or more, use COUNTIFS for “this and that”, and a different approach for “this or that”. The OR case is…
-
COUNTIF Contains Text in Google Sheets: Partial Matches and Wildcards
To count cells that contain a word, rather than cells that equal it, put an asterisk on each side of the word: =COUNTIF(D2:D13, “*apple*”). The asterisk stands for “any characters,…