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")...
excel
JMB17's avatar
JMB17
Bronze Contributor
Feb 17, 2021
Try =SUMIF(A4:A20,"<>Bloggs",B4:B20)
  • 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 (<, >, <=, >=, <>).

      • Joebax86's avatar
        Joebax86
        Copper Contributor
        Feb 17, 2021
        Yeh makes sense, thanks for the explanation.

Resources