Skip to main content

M365 Excel - SUMIF

Christopher Mumpower
Updated
  1. Select a cell where you want to write the formula.
  2. Type =SUMIF(.
  3. Select the range of cells that you want to evaluate by the criteria.

  4. Type a comma and enter the criteria.
     

    Tip: If the criteria is text, don't forget to enclose it with quotation marks ("").

  5. Type a comma and select the SUM range. It'll be the same size and shape as the original range you selected.
  6. Press Enter.

Related to

Comments

0 comments

Please sign in to leave a comment.

Powered by Zendesk