Thread: How do I....
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Farhad Farhad is offline
external usenet poster
 
Posts: 281
Default How do I....

Hi,

countif(A1:A100,"sept")
countif(A1:A100,"oct")
countif(A1:A100,"nov")

Thanks,
--
Farhad Hodjat


"TDW" wrote:

I need to count the number of cells that have dates in them based on the
month which is listed in column A (months are listed as sept, oct, Nov) How
can I do this??