Hi Karen

If you are starting on row 21, then I think you need to amend your
amendment of Bob's formula to reflect that within the MAX function

=IF(E22="Result",ROW()-MAX(MIN(IF($E$21:$E21="Result",
ROW($E$21:$E21))),1)-1,"")
^^^
change to
=IF(E22="Result",ROW()-MAX(MIN(IF($E$21:$E21="Result",
ROW($E$21:$E21))),21)-1,"")



--
Regards

Roger Govier


"Karen McKenzie" wrote in
message ...
Thanks Bob,
This works fine if the data is where you said


21053 £ 192.35
21064 £ 407.36
Result £ 599.71 2
60987 £ 352.61
60988 £ 1,301.75
61254 £ 2,184.32
67225 £ 552.76
Result £ 4,391.44 4



My header row is 21, and my data starts in column E on line 22. I
have
therefore adjusted the formula to read:

=IF(E22="Result",ROW()-MAX(MIN(IF($E$21:$E21="Result",ROW($E$21:$E21))),1 )-1,"")

My results are calculating incorrectly as follows

21053 £ 192.35
21064 £ 407.36
Result £ 599.71 22
60987 £ 352.61
60988 £ 1,301.75
61254 £ 2,184.32
67225 £ 552.76
Result £ 4,391.44 4

Can you tell me where I'm going wrong?

"Bob Phillips" wrote:

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?