Excel, Google Sheets & Shortcuts
Excel Formulas Cheat Sheet
Copyable Excel formula patterns for totals, conditions, lookups, text, dates and error handling.
- Jurisdiction
- Global — Microsoft Excel
- Applies to
- Microsoft 365/Excel 2024 documentation checked 16 November 2026
- Last verified
- 16 November 2026
At a glance
- Formulas start with = and use cell/range references.
- Use $ to lock a row or column when copying a formula.
- Function availability differs across perpetual, Microsoft 365 and web versions; check the function’s Applies To list.
Core formulas
| Task | Formula pattern |
|---|---|
| Total | =SUM(B2:B100) |
| Average | =AVERAGE(B2:B100) |
| Conditional total | =SUMIFS(C:C,A:A,F2,B:B,">="&G2) |
| Conditional count | =COUNTIFS(A:A,F2,B:B,"Open") |
| One condition | =IF(B2>=C2,"On target","Review") |
| Modern lookup | =XLOOKUP(E2,A:A,C:C,"Not found") |
| Index/match lookup | =INDEX(C:C,MATCH(E2,A:A,0)) |
| Filtered rows | =FILTER(A2:C100,C2:C100="Open","None") |
| Join text | =TEXTJOIN(", ",TRUE,A2:A10) |
| Handle expected error | =IFERROR(A2/B2,"Check denominator") |
Dates and references
| Task | Formula pattern |
|---|---|
| Today | =TODAY() |
| Days between dates | =B2-A2 |
| Month end | =EOMONTH(A2,0) |
| Working days | =NETWORKDAYS(A2,B2,Holidays) |
| Absolute reference | =$B$2*A2 |
| Lock row only | =B$2*A3 |
| Lock column only | =$B2*C2 |
1. Confirm data types and blank-cell policy.
2. Use bounded ranges where practical.
3. Lock intended references with $.
4. Test zero, blank, duplicate and missing lookup cases.
5. Audit errors before wrapping them in IFERROR.Practical answers
Frequently asked questions
Use these answers with the dated scope and authoritative sources shown on this page.
What is Excel Formulas?
Copyable Excel formula patterns for totals, conditions, lookups, text, dates and error handling.
What are the most important points about Excel Formulas?
Formulas start with = and use cell/range references. Use $ to lock a row or column when copying a formula. Function availability differs across perpetual, Microsoft 365 and web versions; check the function’s Applies To list.
How should I use this excel formulas cheat sheet?
Read the sections on Core formulas, Dates and references, then use the Copy formula checklist block where it fits your situation. Keep the inputs and assumptions with the copied result so somebody else can review it.
Which jurisdiction and effective date does this page cover?
It covers Global — Microsoft Excel and is labelled for Microsoft 365/Excel 2024 documentation checked 16 November 2026. Rules from another jurisdiction, tax year, product version or contract may produce a different answer.
What should I verify before acting on it?
Confirm exceptions and later changes in the linked material from Microsoft Support. The page was last verified 16 November 2026; provider terms, forms, thresholds, software features and local rules can change after that date.
Authoritative sources
Use the linked source for current instructions and exceptions before acting.
- Using functions and nested functions in Excel formulasMicrosoft Support
Educational reference only. It is not legal, tax, accounting, lending, insurance or investment advice.
