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 and matches the project number I want. Which worked correctly but now I need to exclude some of the values based on another column with text in said sheet. Is this possible?
=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.
2 Replies
=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!!
