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

SUMIFS with multiple not equal to


How to modify the Excel formula such that it will sum column K with column X not in "PENDING" or "TBC" status. Currently, it will sum up column with "PENDING" or "TBC" instead.

2 Solutions
Use not equal sign which is <>
Hakan YılmazTechnical Office MEP EngineerCommented:
You may wish to sum all values up, and then subtract sum of "PENDING" and "TBC" from it.

To prescribe double criteria in one column, you may need to write separately as below. And for that, you don't need to sum again.

Open in new window

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