Put this in C2 and copy down

=IF(A2="Result",ROW()-MAX(MIN(IF($A$1:$A1="Result",ROW($A$1:$A1))),1)-1,"")

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Karen McKenzie" wrote in message
...
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?