View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen McKenzie Karen McKenzie is offline
external usenet poster
 
Posts: 41
Default Counta function question

I have an extract of data that shows detail by item, then an overall result.
I want to use the counta function to count the number of non blank entries
between each entry called result ie:

Equipment Amount Count
21053 192.35
21064 207.30
Result 2
60987 303.20
12156 97.20
30752 1426.67
Result 3

Can this be done?