Forum Discussion
Joebax86
Feb 17, 2021Copper Contributor
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.
4 Replies
Sort By
- JMB17Bronze ContributorTry =SUMIF(A4:A20,"<>Bloggs",B4:B20)