How can I sum a column if another is not equal to multiple criteria?
I'm trying to sum column B if column A is not equal to "Text1" or "Text2" or "Text3".
I cant seem to get a sumif to work with or, it's driving me crazy lol
Posted Apr 27, 2021, 2:36 PM UTC
14
Hmm, you might be forced to do a full sum and then subtract the others. Something like this:
That SUMIF grabs the sum of B2 thru B8 where A2 thru A8 is not-blank. Then it subtracts the SUMPRODUCT result which is grabbing a total of everything that is equal-to our trigger words (of
"this","that"&"other"in the example).Or you could shorten it slightly with this:
Solution verified
Thanks! I didn't end up using this but it was helpful nonetheless!
You have awarded 1 point to mh_mike
^I ^am ^a ^bot, ^please ^contact ^the ^mods ^with ^any ^questions.