Thread: count blank dates
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
s2m via OfficeKB.com
 
Posts: n/a
Default count blank dates
I need to count in 2 columns this condition.

Column Z =< 5/31/06

Column AA = blank date fields

I've tried this but it does not work

=SUMPRODUCT(--(TCS!$Z$2:$Z$1000<="5/31/06"),--(TCS!AA2:AA1000=""))

Much thanks

Sharon

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200606/1
Reply With QuoteReply With Quote