"Ken Wright" wrote in message
...
As Peo pointed out in another post:-
For January you need to add another condition
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(ISNUMBER(A1:A100)))
it's because that excel sees blank cells as zero and excel dates dtart
with
January zero 1900 the unary minuses will convert boolean values of true
and
false to 1 and 0
http://www.mcgimpsey.com/excel/formulae/doubleneg.html
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------
Thank you very much. I hadn't come across this before. It makes sense.
Thanks
Ron