Thread: Ecell 2000 SP3
View Single Post
  #1   Report Post  
holy dog
 
Posts: n/a
Default Ecell 2000 SP3

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