Comments on: SUMIF multiple columns with one or several criteria in Excel

Doing a conditional sum in Excel is a piece of cake as long as all the values to be totaled are in one column. Summing multiple columns is a problem because both the SUMIF and SUMIFS functions require the sum range and criteria ranges to be equally sized. Continue reading →

Comments page 2. Total comments: 57

  1. Please can the SUMIF with conditions return a blank cell?

    1. Hi!
      The SUMIF function returns a number. If nothing is found, it returns 0. You can replace zero with an empty value using the IF function.
      For example,

      =IF(SUMIF(B2:B10, F1, C2:C10) > 0,SUMIF(B2:B10, F1, C2:C10),"")

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)