Hi Folks
I have a formulae that counts the number of dates in a column by the month that they are in:
=SUMPRODUCT(--(MONTH(A2:A398)=B2))
However, although it works for months 2-12, if I select 1 to count any dates in January it counts the entire range?? For example the column has 397 cells, if I leave them all empty it counts 397.
If I enter a date, say, 01/02/2021 and select 2 in B2 it counts 1, if I then reselect 1 in B2 it counts 396??? What am I doing wrong, it's driving me nuts...
Really hoping someone can help please.
Kind regards and thanks in advance
DezB