Yes she is, but she gets #VALUE! for the result. Thanks much for your
assistance.

"Dave Peterson" wrote:

It seems like a very nice formula if your user is counting the number of dates
in January of 1998.

Another formula that's just as nice:
=sumproduct(--(text(index!j3:j9997,"yyyymm")="199801")


holy dog wrote:

I have a user that is using the following function:
=SUMPRODUCT(--(MONTH(Index!J3:J9997)=1),--(YEAR(Index!J3:J9997)=1998))

The cells in question in the index sheet are formated for date ex.
8/29/2005. Is this the correct function for this, if yes what is wrong, if
no what function should i have my user use? Thanks much

--

Dave Peterson