Skip to content

Instantly share code, notes, and snippets.

@davidmerrick

davidmerrick/cheatsheet.md

Last active October 29, 2019 23:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davidmerrick/2e0f28a1256b4b87b4cef9cdcbb88462 to your computer and use it in GitHub Desktop.
Save davidmerrick/2e0f28a1256b4b87b4cef9cdcbb88462 to your computer and use it in GitHub Desktop.
Download ZIP
Excel Cheat Sheet
Raw
cheatsheet.md

Cheat sheet for advanced Excel formulas

Concatenation

Concatenate strings this way:

=A1&” more text”

Absolute reference

By default, references in Excel are relative. For an absolute reference, prefix the column and row with "$"

=$A$2

Reference a cell in another sheet

=Sheet1!A1

COUNTIF and SUMIF

Count cells that match criteria:

=COUNTIF(A2:A, ">1")

Sum cell values if they match criteria:

=SUMIF(A2:A, ">1", B2:B)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment