Can somebody tell me why this array formula is doing this?
I have a table with Prices in one column and Dates in another:
=SUM($G$2:$G$511*(MONTH($H$2:$H$511)=11))
That formula sums November perfectly, but when I do this for December:
=SUM($G$2:$G$511*(MONTH($H$2:$H$511)=12))
For some reason, it's summing every price in column G and not just the ones for December.
I have no idea why this is happening. All I did was change the month portion of the formula for each month and every other month is working except for December.
Any idea?
Bookmarks