View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default How do I count a range of dates in a column?

Check your earlier post.

GBC wrote:

How can I count a range of dates in one column and that range has to include
specific text in another column?

=COUNTA((E3:E58="2/1/2009")*AND(H3:H58="ICO"))

Am I using the wrong formula???


--

Dave Peterson