SUMIFS for Not Equal (<>)

stratman

Thanks for continuing to pursue this. No sir. It is clean.

It's only that second part of the formula that is not working. This part works:

=SUMIFS({Amount}, {SType}, (@cell = "RES602835")

This part doesn't:

, {Fund}, <>"96600")

Nic Larsen

Does it work if you remove the quotes from around the 96600?

{Fund}, <>96600

Paul Newcome

If you have no formatting applied to the Fund column then the fact that it is left justified indicates it is being stored as text and not number. The only way to get this is to include an apostrophe before the number. That apostrophe can throw things off. have you double checked it is not being brought over that way?

stratman

Thanks Nic. Removing the quotations off the latter half worked. Here's the full working formula:

=SUMIFS({Amount}, {SType}, @cell = "RES602835", {Fund}, @cell <> 96600)

I get the apostrophe. Much the same in Excel, but not seeing anything out of sorts in what Data Shuttle is bringing over. I'll give it a look see to be certain.

Thanks again for sticking with this. These are important data points I need to calculate and your hep is much appreciated!