As an Excel user, I have been working with formulas for quite some time now. However, I recently encountered a problem that has left me stumped. I am trying to create a formula that will calculate the total balance of a specific account, but I am having trouble with the “is not equal to” part of the formula.

The first part of the formula works perfectly. It correctly identifies and sums up all the values in column E that are equal to 24. However, when I try to add the “is not equal to” part, the formula stops working altogether.

Here is the formula I am trying to use:

=SUMIFS(‘APXBalances’!C:C,””, ‘APXBalances’!C:C,”00000″, ‘APXBalances’!C:C”05757″)

The formula is supposed to look for all values in column C that are not equal to 00000 or 05757, and then sum up the corresponding values in column A. However, whenever I enter this formula into my spreadsheet, I get an error message saying “Invalid arguments.”

I have tried several different variations of this formula, but none of them seem to work. I have also checked the syntax of the formula multiple times to ensure that there are no typos or incorrect punctuation. However, I am still unable to get the formula to work.

I am hoping that someone out there may be able to help me figure out what is going on and how I can fix this issue. If you have any experience with Excel formulas and can offer some advice, I would greatly appreciate it.

Here is an example of my data:

| by | Tamara Duvall | on | December 29, 2023 |

| — | — | — | — |

| E | 24 |

| C | 12345 |

| A | 735 |

| C | 5757 |

As you can see from the example, I am trying to find all values in column C that are not equal to 00000 or 05757, and then sum up the corresponding values in column A. However, no matter what I try, I am unable to get the formula to work properly.

If anyone out there has any ideas on how I can fix this issue, please let me know. I would be forever grateful for your help. Thank you!