Skip to content

Instantly share code, notes, and snippets.

@yokawasa
Last active November 12, 2021 00:32
Show Gist options
  • Save yokawasa/93df4c91e17ff02a97e097c3d4bfdfcd to your computer and use it in GitHub Desktop.
Save yokawasa/93df4c91e17ff02a97e097c3d4bfdfcd to your computer and use it in GitHub Desktop.
Excel Functions Memo

IF

# IF with ISBLANK
=IF(ISBLANK(CE8),CE7,CE8)
# IF with EQ
=IF(EQ(D3,”m5.large”),E3,0)

SUM & SUMIF

SUMIF(condition range, condition, sum range)

# Simple sum
=SUM(E1:E10)
# SUMIF Equal
=SUMIF(D3:D81,"m5.large",E3:E81)
# SUMIF Not Equal
=SUMIF(D3:D81,"<>m5.large",E3:E81)
# SUMIF Greater than
=SUMIF(D3:D81,">100",E3:E81)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment