Google Sheets formulas that work the first time
Step-by-step tutorials, fixes for formula errors and free tools. Every formula is tested in Google Sheets before we publish it.
Latest guides
-
How to Remove Duplicates in Google Sheets (Menu, UNIQUE and What Each One Keeps)
Google Sheets has two ways to remove duplicates: the Remove duplicates command, which deletes rows from your data, and the UNIQUE function, which builds a clean copy somewhere else. They…
-
How to Highlight Duplicates in Google Sheets (Every Copy, Repeats Only or Whole Rows)
Google Sheets doesn’t have a one-click “highlight duplicates” option, but a conditional formatting rule with a short COUNTIF formula does the job. The formula decides what gets colored: every copy…
-
Find Duplicates Between Two Columns in Google Sheets (Matches and Missing Values)
To find the values that appear in two lists, ask for each value in the first list whether the second list contains it. COUNTIF and MATCH both do that, FILTER…
-
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…
-
IF with Multiple Conditions in Google Sheets: AND, OR, Nested IF and IFS
IF checks one condition and returns one value if it’s true and another if it’s false. Real decisions usually need more: pass only if the score and the attendance are…
-
IF a Cell Contains Text in Google Sheets (Partial Match)
To return something when a cell contains a word, not when it equals it, IF needs help from a function that searches inside text. The first thing most people try,…
-
ARRAYFORMULA with IF in Google Sheets: One Formula for the Whole Column
A normal IF formula works on one row, so you copy it down the column. ARRAYFORMULA lets a single formula in the top cell fill the whole column, and it…
-
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:…