SUMIF AND EXCLUDE VALUES

[Maria760]

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 · Accepted 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.

 

[#3]

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