# IF with ISBLANK
=IF(ISBLANK(CE8),CE7,CE8)
# IF with EQ
=IF(EQ(D3,”m5.large”),E3,0)
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)
- ref: SIMIF Function