Thread: Count items when specific text and date criteria are met
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips
 
Posts: n/a
Default Count items when specific text and date criteria are met
The #NUM could be caused by TDate not being the same size as TQ7. Ranges
must be the same size in SP.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"javamom" wrote in message
oups.com...
Thanks for the response! The above returns a #NUM! error for me.

Do you think that calculating TDate with =DATE(D2,B2,C2) could be
causing a problem?



Reply With QuoteReply With Quote