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 Blank Rows in Google Sheets (Formulas and Sort, Tested)
There are two ways to get rid of blank rows in Google Sheets. A formula such as FILTER or QUERY builds a clean copy and leaves the original untouched. Sorting…
-
Google Sheets FILTER Not Working? 9 Causes We Reproduced
When FILTER fails in Google Sheets, it either shows an error or, worse, returns rows that look plausible but are wrong. We broke FILTER on purpose in a test sheet…
-
Google Sheets FILTER with Multiple Conditions (AND, OR, Dates and Text)
FILTER returns the rows of a range that meet one or more conditions. One condition is easy. With several, you have to choose how to join them: all of them…
-
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,…