About

SheetLever publishes practical Excel and Google Sheets tutorials — the kind you reach for when a formula isn't working and you need the answer in the next five minutes.

What you'll find here

  • Formula guides — lookups, conditional logic, text functions, and the errors that break them
  • Error fixes — #N/A, #REF!, #SPILL! and the rest, with the actual causes rather than generic advice
  • Free templates — budget trackers, project sheets, invoices and inventory lists, ready to download and use
  • Comparisons — VLOOKUP or XLOOKUP, Excel or Google Sheets, and which one fits your situation

How the guides are written

Every tutorial answers the question in the first paragraph, then explains why. No long preamble, no padding to hit a word count.

Every formula published here is tested in Excel before it goes up, and the screenshots are taken from those same test sheets — not borrowed from elsewhere. Where a function only works in certain versions of Excel, that's stated plainly, because a formula that fails silently in someone else's copy of Excel is worse than no formula at all.

Who writes it

SheetLever is written by Adam Reid. I'm not a Microsoft employee, a certified trainer, or affiliated with Google. I'm someone who spends a lot of time in spreadsheets and writes down what actually works.

If a guide here is wrong or incomplete, I'd rather know. Corrections are welcome and get made.

Get in touch

Questions, corrections, or a suggestion for a topic: use the contact page.

Comments

Post a Comment

Popular posts from this blog

How to Pull Data From Another Google Sheet Automatically

Image
One function pulls data from another Google Sheets file: =IMPORTRANGE("https://docs.google.com/spreadsheets/d/1AbC.../edit", "Sheet1!A1:D100") It will return #REF! the first time. That's expected, and the fix is one click — covered immediately below, because it's where everyone gets stuck. The formula is correct. This is Sheets asking permission to connect the two files, and it only asks once. The step nobody mentions The first time you import from a particular file, the formula returns #REF! rather than data. Hover over the cell and a small prompt appears: "You need to connect these sheets" , with an Allow access button. Click it. The data appears within a second or two. This is a deliberate security step, not a bug. It means nobody can silently pull data out of a file you own by knowing its URL — someone has to explicitly authorise the connection, and only someone with edit access to both files can do it. ⚠️ The authorisation ...
Read more

Excel Shows the Formula Instead of the Result — Fix It

Image
If every formula on the sheet is showing as text, press Ctrl+` — the grave accent key, above Tab, sharing with the tilde. That's Show Formulas, and it's on. If only some cells are affected, it's a different problem with a different fix, and the rest of this guide is about those. Three cells that never computed anything, and one that did. The only difference is what was in the cell before the formula went in. Which problem do you have? Symptom Cause The whole sheet, and the columns went wider Show Formulas is on One cell or column, text sitting to the left The cell holds text, not a formula Some sheets affected, others not Show Formulas — it's a per-sheet setting The widened columns are the giveaway for Show Formulas. Excel widens them to fit the formula text, and narrows them again when you turn it off. ⚠️ Show Formulas is saved with the file and set per sheet, not per workbook. A colleague can send you a file already in that stat...
Read more

Why Your Totals Are Wrong: Numbers Stored as Text

Image
SUM silently ignores text. A column that looks entirely numeric can contain a few text entries, and your total will simply be wrong — no error message, and no indication in the total itself that anything was left out. One formula tells you whether it's happening: =COUNTA(D2:D500) - COUNT(D2:D500) COUNTA counts anything; COUNT counts only numbers. Anything other than zero is how many cells are lying to you. Fourteen invoices, five of them invisible to SUM. The total is understated by 7,735 and looks entirely reasonable. Why this one matters more than the others Every other error in Excel announces itself. #N/A , #REF! , #VALUE! — you can see them and go and fix them. This one produces a plausible number. In the example above the sheet reports 10,247 where the true figure is 17,982 — understated by more than 40%. The only hint is a small green triangle in the corner of five cells, and a difference in which side of the cell the figures sit on. Neither appears anyw...
Read more