Formula answers you can test
60 answers to the spreadsheet questions people ask most. Every formula on these pages has been run and checked by our formula engine, sits in a live sheet you can edit, and comes with an exercise that grades your own version.
Most asked
- How to use VLOOKUP to find an exact match in Excel
=VLOOKUP(G1,A2:D9,3,FALSE) - How to count cells that contain specific text in Excel
=COUNTIF(A2:A10,"*"&D1&"*") - How to sum values based on criteria in Excel (SUMIF)
=SUMIF(B2:B11,G1,D2:D11) - How to use IF with multiple conditions in Excel
=IF(AND(B2>=$G$1,C2>=$G$2),"Bonus","No bonus") - How to find duplicates in a column in Excel
=IF(COUNTIF($A$2:$A$10,A2)>1,"Duplicate","") - How to calculate percentage change between two numbers in Excel
=(C2-B2)/B2 - How to calculate age from a date of birth in Excel
=DATEDIF(B2,$F$1,"y") - How to look up a value with two criteria in Excel
=XLOOKUP(1,(A2:A8=G1)*(B2:B8=G2),D2:D8) - How to filter rows based on a condition with a formula in Excel
=FILTER(A2:C10,B2:B10=G1) - How to count unique values in Excel
=COUNTA(UNIQUE(A2:A10)) - How to calculate the number of days between two dates in Excel
=C2-B2 - How to extract the first name from a full name in Excel
=TEXTBEFORE(A2," ")
By topic
Counting formulas
Count rows that match one condition or several, between dates, by text, blanks and unique values.
Sum formulas
Totals with conditions, running totals, totals across columns and ranges that grow.
Lookup formulas
Find a value and bring back what goes with it: by ID, by two keys, the last match, the closest match.
IF and logic formulas
Flags, pass and fail, grades, multiple conditions and hiding errors the right way.
Text formulas
Split, join, extract and clean text: names, emails, codes and messy imports.
Date formulas
Days between dates, working days, ages, month ends, quarters and adding months.
Dynamic array formulas
FILTER, SORT, UNIQUE and friends: one formula that returns a whole table.
Duplicates and data cleanup formulas
Find, flag, count and remove duplicates, and fix numbers stored as text.
Rounding and math formulas
Round to any step, round up and down, weighted averages, ranks and remainders.
Percentage formulas
Percent of total, percent change, adding and removing a percentage, and margins.
How these answers are checked
Each answer is data, not just text: a sample sheet, the formula, the expected result and the alternatives. Before a page is published, our formula engine runs the formula, compares it with the expected result, runs the Google Sheets version in Sheets mode, checks that every alternative agrees, and checks that the practice exercise rejects a typed-in answer. If any check fails, the page isn't built. Last run 2026-10-29.
Want the reasoning behind a function rather than a quick answer? See the function library or the lessons.