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

TaskFormula 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

TaskFormula 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.

Educational reference only. It is not legal, tax, accounting, lending, insurance or investment advice.