Practisheet

Free formula checker for Excel

Paste your data and a formula to see the result and a plain-English breakdown of every function. Free, no sign-up, runs in your browser.

Guide: SUMIF With Multiple Criteria: How SUMIFS Works
H2fx
ABCDEFGHI
1OrderDateRegionCategoryStatusAmountResult
210012025-01-06NorthOfficecompleted4201100
310022025-01-09WestKitchencompleted310
410032025-01-14WestOfficerefunded150
510042025-01-20SouthCleaningcompleted275
610052025-02-03WestOfficecompleted560
710062025-02-11NorthKitchencancelled190
810072025-02-17WestCleaningcompleted230
910082025-02-24EastOfficecompleted385
10
11
12

Cell H2

Result 1100

=SUMIFS(F2:F9,C2:C9,"West",E2:E9,"completed")
  1. 1.SUMIFS adds the rows that match every criteria

    • range_to_addF2:F9is F2:F9, 8 cells
    • range1C2:C9is C2:C9, 8 cells
    • criteria1"West"
    • range2E2:E9is E2:E9, 8 cells
    • criteria2"completed"

    Gives 1100

Report a difference from Excel

This excel formula checker works like a small spreadsheet with a second pair of eyes. Type or paste a formula into any cell and it shows the result, then breaks the formula into its functions, innermost first, with the value of every argument. It is the same idea as Evaluate Formula in Excel, but every step is visible at once and written in plain English.

Nothing is sent anywhere. The formula runs in your browser on the same engine that checks answers in our practice exercises, so it needs no account and no download.

How to use the formula checker

  1. Start from the sample or your own data. The sheet opens with eight orders from Brightline Supply Co., a made-up office supplies company: order number, date, region, category, status and amount. Pick another formula from Examples, or press Clear and paste your own cells. A block copied from a spreadsheet keeps its rows and columns.
  2. Type a formula in any cell. Start with =, as in Excel. On a phone, tap a cell, then type in the formula bar above the sheet. While you type, the cells and ranges the formula refers to are outlined in colour, and the panel below the sheet updates as soon as you press Enter.
  3. Read the breakdown. The panel follows the selected cell. For a formula such as =IFERROR(ROUND(SUMIFS(F2:F9,C2:C9,"West")/COUNTIFS(C2:C9,"West"),2),0) it lists SUMIFS first, then COUNTIFS, then ROUND, then IFERROR. Each step names the arguments (range_to_add, range1, criteria1 and so on), shows what you passed, and shows what that part comes to. Ranges are summarised as "C2:C9, 8 cells" so long lists don't drown the answer.
  4. Fix what it flags. Errors get a red edge and one line on the usual cause: #DIV/0! divides by an empty or zero cell, #N/A is a lookup with no match, #VALUE! is maths on text. Where a guide covers the fix, the panel links to it.

Two common problems get a one-click fix. If your formula uses semicolons between arguments, as Excel does with some regional settings, the checker offers to switch them to commas. If your data came in as text, such as "$1,200.00" or "12%", sums quietly skip it; Convert to numbers turns those cells into real numbers, dates included.

What the checker is good for

  • Testing a formula before you rely on it. Check that a SUMIFS really adds the rows you think it adds, on data small enough to verify by eye.
  • Understanding someone else's formula. Paste a long nested formula from a colleague or an AI assistant and read what each layer does, in order.
  • Finding the step that breaks. When a formula returns an error, the breakdown shows which inner step produced it, so you fix the right part instead of rewriting the whole thing.
  • Learning a function. Every step comes with a one-line description of what the function does, and the examples link to a full guide.

To follow a formula's inputs back through the sheet in Excel itself, the guide to tracing precedents covers the built-in auditing tools.

What it can't do yet

The checker runs nearly 100 functions: the lookup, conditional, text, date, maths and dynamic array functions analysts use most, including XLOOKUP, SUMIFS, COUNTIFS, FILTER, SORT, UNIQUE and LET.

  • Some functions are missing. CHAR, CODE, SQRT, YEARFRAC, TEXTAFTER, LAMBDA, INDIRECT and OFFSET show #NAME? with a note on what to use instead. TODAY, NOW and RAND are left out on purpose, because their results change every time.
  • One sheet only. References to another sheet (Sheet2!A1), table references (Table1[Amount]) and named ranges are not read. Paste the data into this sheet and point at the cells.
  • 50 rows and 12 columns. Whole-column references such as C:C work and are read as rows 1 to 50. A result that spills past the edge shows only the part that fits.
  • A few results differ from Excel. SORT orders text more simply than Excel, very large spills are cut off, and a reference to the formula's own cell shows #CIRCULAR! where Excel shows a warning.

If you find a formula that gives a different answer from Excel, the Report a difference from Excel link under the breakdown sends us an email. Please include the formula and what Excel shows.

FAQ

Is this formula checker free?

Yes. It needs no account and no sign-up, and there is no limit on how many formulas you check. It runs in your browser, so your data stays on your device.

How do I check if an Excel formula is correct?

Put a small copy of your data in the sheet, enter the formula, and compare the result with an answer you can work out by hand. Then read the breakdown: every step shows its value, so a wrong range or criteria shows up in the step where the number first goes wrong.

Why does my formula show #NAME? here when it works in Excel?

Either the function is one the checker doesn't have yet, or it points at another sheet, a table or a named range. The panel says which. Rewrite that part with plain cell ranges, or use the alternative the note suggests.

Can it explain a formula an AI assistant wrote?

Yes. Paste the formula with a few rows of matching data and read the steps. AI assistants often get a range, a criteria or the order of arguments slightly wrong, and the step-by-step values make that easy to spot.

Why does SUM ignore some of my numbers?

They are stored as text, often because they came from a CSV export with currency signs or thousands separators. The checker spots cells like "$1,200.00" and offers Convert to numbers. In Excel, VALUE or Text to Columns does the same job.

Checking a formula is step one. Practise on one realistic company's data with instant feedback that never gives away the answer. First 5 Excel exercises free.

Start the free Excel exercises →