Explore / Formulas

Formulas

Find the right function. Understand every argument.

Google Sheets FILTER Function: Practical Examples and Common Errors

Copy Google Sheets FILTER examples for one condition, AND, OR, and no matches, using a five-row dataset with expected outputs.

4 min read

Formulas↗

IFERROR vs IFNA in Excel and Google Sheets: Fix Errors Without Hiding Problems

Learn when to use IFERROR or IFNA in Excel and Google Sheets, with two reproducible example tables, a diagnostic decision tree and safer error-handling formulas.

11 min read

Formulas↗

SUMIFS with Dates: A Step-by-Step Excel and Google Sheets Tutorial

Sum monthly amounts using an inclusive start and exclusive next-month boundary, with timestamp edge cases and expected Excel/Sheets totals.

4 min read