That worked! Thank you so much, both Gary and Dave. I combined both of your
suggestions and it was successful.



Gary L Brown wrote:
Not tried but won't the following do?
=SUMPRODUCT(--(ISNUMBER(Sheet1!D6:D28)),--(MONTH(Sheet1!D6:D28)=J6),--(YEAR(Sheet1!D6:D28)=2006))

I need to get a few counts of data I have entered in several columns filled
with dates from 2004 through 2006 (and will be soon be populated with more
[quoted text clipped - 17 lines]

Any assistance is GREATLY appreciated!

--
Thank you,
Amy@H-D

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200601/1