Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 62
  • Last Modified:

excel formula need to add a NOT equal value

I have the following formula that works fine:

But a new wrinkle popped in, I can't add values that have the word Commit in column D.  How would that impact the formula above?

Matt Pinkston
Matt Pinkston
2 Solutions
Ejgil HedegaardCommented:
Use the criteria "<>*Commit*" like this

Open in new window

Mark BullockQA Engineer IIICommented:
You could use a formula like the following to return the number or 0 if it's not a number:

Open in new window

You can combine both SumIfs into one this way:

Open in new window

Matt PinkstonAuthor Commented:
Excellent, thanks go me the data I needed
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now