Dear all...

Is there a way of suming a column of data based firstly on a criteria
(E.g. Name = "Bob") and then on the relative order in which the values
appear in the list (E.g. Sum the 1st, 2nd, 3rd & 4th instances of
"Bob").

Essentially what i'm looking for is a formula that will sum the values
for the fist 10 instances (1 to 10) of Bob.
But also the ability to change the criteria. E.g.
instances 11 to 20, 21 to 30, 31 to 40, etc.

To illustrate...

Name Value
Bob 5
Ted 2
Fred 6
Bob 4
Fred 2
Bob 5
Bob 1
Ted 4
Bob 2

E.g.
Bob instances 1 to 3 would equal 14
Bob instances 4 to 5 would equal 3

Etc...

I'd need to do this without re-ordering the data.

Hope you can help