SOLVED

# SUMIF AND EXCLUDE VALUES

Copper Contributor

# 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?

2 Replies
best response confirmed by HansVogelaar (MVP)
Solution

# Re: SUMIF AND EXCLUDE VALUES

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

# Re: SUMIF AND EXCLUDE VALUES

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

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

# Re: SUMIF AND EXCLUDE VALUES

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