Forum Discussion

Joebax86's avatar
Joebax86
Copper Contributor
Feb 17, 2021

SUMIF and NOT functions

Hi,

Just trying to get my head around the best way to calculate the sum of values from one column but excluding some based off a name in another.

I tried the following:

=SUMIF(A4:A20,NOT("Bloggs"),B4:B20)

But it just returns a 0,

I

Am i along the right lines or is their a different way to do this.

Thanks.

excel

4 Replies

    • Joebax86's avatar
      Joebax86
      Copper Contributor
      Feb 17, 2021

      JMB17 

      Great thanks that works,

      I'm guessing <> basically means "not equal to"?

      • JMB17's avatar
        JMB17
        Bronze Contributor
        Feb 17, 2021

        Correct. When you enter SUMIF(A4:A20,"Bloggs",B4:B20), the "=" is implicit, so think of it as SUMIF(A4:A20,"=Bloggs",B4:B20), but you can use other conditional comparison operators (<, >, <=, >=, <>).

Resources