Nested If and in array formula not working

[dsrt16]

Here is the array formula that is not working: {=SUM(IF((AND(MONTH(A9:A84)=1,B9:B84="Income")), E9:E84,0))}

I am trying to calculate the gross for January.

So it looks at the date (column A) and searches for January, then looks in the type (column B) and searches for income. If that row has both January and income, then I want it to add up the amount (column E).

Since this is the gross earnings and not the net, it needs to ignore the "expense" type charges and the "taxes" type charges, and only add the amounts that are income in January.

Right now, it is just returning $0.00 even though there is income for January. I am sure I made a simple error in the formula somewhere, but I can't spot it. ANy ideas?

My array formula to calculate the net is working: {=SUM(IF(MONTH(A9:A84)=1, E9:E84,0))}

This adds all amounts for January (income, expense, tax). It adds everything that is only listed as January. And this is working. It returns the correct net amount.

[Phuocam]

The array formula does not support and (), or ().
change and () to *, or() to +

=SUM(IF((MONTH(A9:A84)=1)*(B9:B84="Income"), E9:E84,0))

[dsrt16]

That worked. Thanks!

[AlKey]

Or use regular formula

Please Login or Register  to view this content.