I am looking to add an AND, OR, or NOT to my formula or a combination of these
Right now I have
Col A Col b Col C
sumif(column A, "XXXX", column c) (column A meets X criteria then sum
col. c)
I want the formula to be if column a meets x criteria and the value in
column b is either Y or Z but not e, f, g then sum col c.
If tried a bunch of different options with AND and OR but can't seem to put
it together in the right order.
Can you provide some guidance?
Thanks.