I have the following array formula to configure the net for that January. {=SUM(IF(MONTH(A10:A85)=1, E10:E85,0)} The problem is I don't attribute taxes to a given month. So when I have a tax line entered in the date column (A) is blank. Yet, it calculates that blank row for January.
Example (I just put in random numbers as an example):
example.png
The January net is wrong. It should be 1,534.18, but it is subtracting the January taxes and February taxes even though there is no date line for those rows. It seems if there isn't a date, it automatically assumes it is 1 (and counts it for January).
The February one works correctly. {=SUM(IF(MONTH(A10:A85)=2, E10:E85,0)} And all the others do as well.
Is there a way to get that January formula to treat blank cells in the A column as blank rather than attributing them to month 1?
Bookmarks