Forum Discussion
Solved
SUMIF AND EXCLUDE VALUES
I am trying to exclude values based on a specific text. I used used sumif to sum values based on a project number in one sheet and pull from another sheet where the column lists two project numbers ...
=SUMIFS(C2:C10,D2:D10,"north",E2:E10,"<>old")With SUMIFS you can exclude some values based on text like in the example. An alternative could be SUMPRODUCT.
=SUMIFS(C2:C10,D2:D10,"north",E2:E10,"<>old")With SUMIFS you can exclude some values based on text like in the example. An alternative could be SUMPRODUCT.
OliverScheurich Thank you! That formula worked for me!!