This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I am trying to use not equal to (<>) with a sumifs formula and it's not summing the correct number. Below shows the formula using, you can see if I use the <> it is summing the total. I got the formula from a sample on the How to Use the Excel SUMIFS with Not Equal to Text Criteria: 4 Examples. I can't get it to work my sample data, but if I switch up the data from the website it works perfectly not sure what wrong with my data.
Any suggestion on how to fix the formula, to get to sumifs correctly get the total correct. In the data set there are many more PL's, and I am trying to make the formula as simple as possible.
https://www.dropbox.com/scl/fi/fuvc5a02gpm94eat003i6/Sumifs-doesn-t-equal.xlsx?rlkey=7l05kb0qbkxjc095glzonx8da&st=dmd5zn49&dl=0 Sample file
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 79%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERA%3C/text%3E%3C/svg%3E)
The PL cells are stored as text. Convert them to number and the formula will work:
Hi,
Share data in a format that can be pasted in an MS Excel file.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
The issue depends on your file / wrong data format in the cells. If I paste your data into my file it works:
I10: =SUM(SUMIFS(I2:I5,B2:B5,A9:A10,C2:C5,"<>"&C9,C2:C5,"<>"&C10))
We need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community
Andreas.
Hi Andreas,
I have updated the original post with the sample of the file. I am still not getting the correct answer, what cells are wrong data format that is preventing getting the correct answer.