SOLVED

SUMIF AND EXCLUDE VALUES

Copper Contributor

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?

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Maria760 

=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.

exclude values.JPG 

@OliverScheurich Thank you! That formula worked for me!!

1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@Maria760 

=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.

exclude values.JPG 

View solution in original post