Forum Discussion

rkenisto's avatar
rkenisto
Copper Contributor
Jun 18, 2020

Blank cell as criteria for SUMIFS

I have 3 columns I need to look at to add certain numbers in my 4th column, and the third criterion column must be blank in order to add the number in the 4th cell. Here is the formula I've been trying to use:

=SUMIFS(K5:K123, B5:B123, "X", C5:C123, "Y", J5:J123, "")

The total column says 0 although there are numbers that should be added. I have also tried "=" for the blank criteria. Please help

8 Replies

  • Wadelf's avatar
    Wadelf
    Copper Contributor

    =SUMIFS(UnitValue,Modelos,$H68,CorM,$U68,PeriodStart,$W68,AllocationMethod,"="&$V68)
    V68 is blank. It does not work with just the reference to the blank cell. In other situations, "=" will work.
    You just have to add the "=" to make it work? Not sure why?

     

  • wumolad's avatar
    wumolad
    Iron Contributor
    Hi rkenisto

    You can try this:

    =SUMIFS(K5:K123, B5:B123, "X", C5:C123, "Y", J5:J123, "=")

    Cheers
    • rkenisto's avatar
      rkenisto
      Copper Contributor

      wumolad 

       

      I have tried that as well and end up with the same results. It is starting to make me think something is wrong with the sheet or data i was given. Anyways, thank you for the help!

      • wumolad's avatar
        wumolad
        Iron Contributor
        rkenisto

        Are you able to share the file so I can take a look, as long as there are no sensitive information therein.

        Cheers

Resources