Feb 17 2021 12:30 PM
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.
Feb 17 2021 12:44 PM
Feb 17 2021 01:28 PM - edited Feb 17 2021 01:32 PM
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 (<, >, <=, >=, <>).