Excel Formulas Cheat Sheet

Useful Excel formulas for sums, logic, lookups and cleaning up spreadsheet data.

SummariesLogicLookupsText cleanup

Core formulas

=SUM(A1:A10)
=AVERAGE(A1:A10)
=MIN(A1:A10)
=MAX(A1:A10)

=IF(A1>10,"Yes","No")
=COUNTIF(A:A,"Done")
=SUMIF(B:B,"North",C:C)

=XLOOKUP(E2,A:A,B:B)
=INDEX(B:B,MATCH(E2,A:A,0))

=CONCAT(A1," ",B1)
=TEXTJOIN(", ",TRUE,A1:A5)
=IFERROR(A1/B1,0)

=TODAY()
=NOW()
=DATEDIF(A1,B1,"d")
=ROUND(A1,2)
=TEXT(A1,"dd-mmm-yyyy")

✓ Copied!