View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carlo Carlo is offline
external usenet poster
 
Posts: 179
Default Not sure if count is the correct formula... Excel 2002

I have a formula that I use for every job I complete that is inserted into
the "Time" column, and above this I have "Jobs" basically count the number of
Jobs I have completed for the week =COUNTA(F6:F47), however since I have
added the new formula to the "Time" cells it is counting all of them, how do
I resolve this issue