SUM If with multiple Not equal to criteria.
I am having trouble with the formula below. The first part works perfectly. It is when I get to the is not equal to part that the formula does not work.
=sumif(‘APXBalances’!E:E,’APXBalances’!B:B=24,’APXBalances’!A:A”0735″)-SUMIFS(‘APXBalances’!C:C,”<>”,’APXBalances’!C:C,”<>00000″,’APXBalances’!C:C”<>05757″)
Here is an example of my data
FundAYAPPNRemaining Cash Balance BudgetAppropriation Cash AvailableAppropriation Accrued Cash Available073522 052623.4252623.4207352200000014899.9814899.980735220575500007352205862037723.4437723.4407352213001000
I am having trouble with the formula below. The first part works perfectly. It is when I get to the is not equal to part that the formula does not work. =sumif(‘APXBalances’!E:E,’APXBalances’!B:B=24,’APXBalances’!A:A”0735″)-SUMIFS(‘APXBalances’!C:C,”<>”,’APXBalances’!C:C,”<>00000″,’APXBalances’!C:C”<>05757″) Here is an example of my data FundAYAPPNRemaining Cash Balance BudgetAppropriation Cash AvailableAppropriation Accrued Cash Available073522 052623.4252623.4207352200000014899.9814899.980735220575500007352205862037723.4437723.4407352213001000 Read More
