Hi Michael

Sorry, typos on my part
They should have read

=SUMPRODUCT(--(MONTH($A$1:$A$200)=1))
and
=SUMPRODUCT(--(MONTH($A$1:$A$200)=ROW(F1)))

Also, it depends upon the dates being Excel dates and not text
representations of the date.
In another cell, type =ISNUMBER(A1) It should return TRUE if it is an Excel
date.

If you have Text values in column A, mark the whole column then
DataText to columnsNextNextDateDMYFinish and that will convert them to
true numeric Excel dates.

--
Regards
Roger Govier

"Michael" wrote in message
...
Thank you Roger,
Unfortunately I get result 200 every time for your 1st and 2nd formula.
Kind regards,
Michael