View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sabrina sabrina is offline
external usenet poster
 
Posts: 10
Default Counting number of cells

I need to count the number of cells that indicate "utd" within a certain time
frame.

ie; column E holds dates formated 1-12
column H holds data 'utd', 'in progress' or 'failed'

I need to calculate how many 'utd' accounts within the month of '1' (Jan).
I cannot seem to find a formula that will work for me...please help