Formula explainer
Paste an Excel or Google Sheets formula. Get it in plain English, step by step. It runs in your browser: nothing is sent anywhere.
In plain English
Adds up the values in D2:D20 on the rows where B2:B20 is equal to "North" and C2:C20 is greater than or equal to H1.
Works in: all current Excel versions, Google Sheets
Where each function is taught
Step by step
What each part does.
- 1SUMIFS
=SUMIFS(D2:D20, B2:B20, "North", C2:C20, ">="&H1)= 0Adds up the values in
D2:D20on the rows whereB2:B20is equal to"North"andC2:C20is greater than or equal toH1.sum_range D2:D20the cells to add range1 B2:B20the first column to check criteria1 "North"what it must match range2 C2:C20the next column to check criteria2 ">="&H1what that must match From the course:
Lesson 19SUMIFSadds the rows that match all of several conditions, like “Plants and Shipped”.
Try it on a sample sheet
We filled the cells your formula reads with sample numbers and put the formula in J1. Type your own values (text works too) and watch the result and the steps above update.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 39 | 0 | ||||||||
| 2 | 64 | 81 | 98 | |||||||
| 3 | 11 | 28 | 45 | |||||||
| 4 | 48 | 65 | 82 | |||||||
| 5 | 85 | 12 | 29 | |||||||
| 6 | 32 | 49 | 66 | |||||||
| 7 | 69 | 86 | 13 | |||||||
| 8 | 16 | 33 | 50 | |||||||
| 9 | 53 | 70 | 87 | |||||||
| 10 | 90 | 17 | 34 | |||||||
| 11 | 37 | 54 | 71 | |||||||
| 12 | 74 | 91 | 18 | |||||||
| 13 | 21 | 38 | 55 | |||||||
| 14 | 58 | 75 | 92 | |||||||
| 15 | 95 | 22 | 39 | |||||||
| 16 | 42 | 59 | 76 | |||||||
| 17 | 79 | 96 | 23 | |||||||
| 18 | 26 | 43 | 60 | |||||||
| 19 | 63 | 80 | 97 | |||||||
| 20 | 10 | 27 | 44 |
Practise this in 5 minutes
Everything this formula uses is taught in Lesson 19: SUMIFS (Unit 5, Conditional totals), on a live sheet with instant feedback. Pro
Open “SUMIFS”Need a quick reference? The formula cheat sheet is free to read and print.
How the formula explainer works
It reads your formula with the same engine that grades formulastreak's lessons, then describes each function in the order a spreadsheet calculates it: the innermost first. Every argument gets a name and a plain-English meaning, taken from the lesson that teaches that function.
Then it builds a small sample sheet around the cells your formula reads, so you can see what each step returns and change the numbers to test it. Nothing is uploaded: it all happens in this page.
Want to understand the errors instead? Try the Excel error decoder, or read the formula guides.
Popular formulas, explained
- VLOOKUP + IFERROR
=IFERROR(VLOOKUP(F2,$A$2:$C$9,3,FALSE),"Not found") - INDEX MATCH
=INDEX($C$2:$C$9,MATCH(F2,$A$2:$A$9,0)) - SUMIFS
=SUMIFS(D2:D20,B2:B20,"North",C2:C20,">="&H1) - IF with AND
=IF(AND(B2>=100,C2="Yes"),"Bonus","No bonus") - XLOOKUP
=XLOOKUP(G2,A2:A9,C2:C9,"Missing") - COUNTIF wildcard
=COUNTIF(A2:A20,"*shirt*") - Percent change
=ROUND((C2-B2)/B2,3) - FILTER
=FILTER(A2:C20,B2:B20="West","None")
Questions
Which formulas can it explain?+
Any formula written for Excel or Google Sheets: it reads cell references, ranges, operators, text, nested functions, LET and LAMBDA. It describes about 150 functions in detail. If it meets a function it doesn't know yet, it says so and still explains the rest.
Does my formula leave my computer?+
No. The explanation and the sample sheet run entirely in your browser. Nothing you paste is sent to our server.
Why does it explain the formula inside-out?+
That's the order a spreadsheet works it out: the innermost functions first, then the functions that use their results. Reading it in that order makes long formulas much easier to follow.
Does it work for formulas from another sheet or workbook?+
Yes. References like Prices!A2:C9 are explained without the sheet name. Excel table references like Table1[Amount] aren't supported yet.
Is it the same in Excel and Google Sheets?+
Most formulas are. Below each explanation you'll see which versions of Excel and whether Google Sheets support every function it uses.