Formula guide · Excel · Updated May 13, 2026
Excel Formula Cheat Sheet
A practical cheat sheet of common Excel formulas for lookup, counting, text cleanup, dates, and errors.
Quick Answer
The most useful Excel formulas for everyday work are XLOOKUP, SUMIFS, COUNTIFS, FILTER, TEXTJOIN, IFERROR, WORKDAY, and NETWORKDAYS.
Copyable Formula
=XLOOKUP(value, lookup_range, return_range)Syntax
Use this page as a quick reference, then open the detailed guide for examples.Excel
Worked Example
| Task | Formula |
|---|---|
| Find a value | XLOOKUP |
| Sum with conditions | SUMIFS |
| Count with conditions | COUNTIFS |
| Clean errors | IFERROR |
Result: Use the cheat sheet to choose a formula, then open the related page for copyable examples.
Steps
- Start with the task you need to solve.
- Choose the simplest formula that fits the task.
- Open the full guide when you need syntax details or mistakes to avoid.
Common Mistakes
- Choosing a complex formula when a pivot table would be clearer.
- Using lookup formulas where a source table needs cleanup first.
- Ignoring compatibility with older Excel versions.
Excel vs Google Sheets Notes
This page is focused on Excel. If you need Google Sheets compatibility, check whether your Sheets account supports the same function or use one of the related alternatives.
Editorial check: This guide was last updated May 13, 2026. Formula behavior can vary by Excel version, Google Sheets rollout, and spreadsheet locale.