Hi Bob,

I've just deleted the data that I had at the top of my spreadsheet so that
my data starts in row 2. The first two results calculate correctly but after
that it is incorrect.

Equipment Quantity Price unit Amount
21053 4.000 EA 315.370 £ 192.35
21064 18.000 EA 311.730 £ 407.36
Result 22.000 EA 627.100 £ 599.71 2
60987 * 332.790 £ 352.61
60988 63.000 EA 992.040 £ 1,301.75
61254 * 1,740.120 £ 2,184.32
67225 * 580.100 £ 552.76
Result * 3,645.050 £ 4,391.44 4
62619 * 497.300 £ 396.69
62621 * 1,000.150 £ 1,152.65
62625 * 149.060 £ 169.35
Result * 1,646.510 £ 1,718.69 8


"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?