Total stakes won from previous starts.

Hello all,

I'm hoping to get a macro that can total the stakes in col AU for each name in col AH.
I have 620,000 rows to process and this is just a sample of four names only, there are over 10,000 plus different names.

I have started resulting in col I. The first two names, but haven't completed the second name yet.

My result is adding up all if any stakes for each individual name only for all of its previous dates only.

Cell I9 has won $17,935 to date in its last 5 starts.
Cell I10 would result 18,285 and so on until a new name is found, then the process would start again.

I think this is simple, but open to questions if I left something out. A function would start me off, just have to turn to values, etc.

Thanks.

If all you need is the total by horse then you can generate a unique list of names by putting

Please Login or Register  to view this content.

in cell AV1

and then in AW2 put

Please Login or Register  to view this content.

and copy it down.

Thanks for that, gives me a total.
I'm needing the same results I have in col I. My whole database is made of 60,000 races, so each race will be different, I need to know what they have earned with each start.

Thanks.

in I2

Formula:

Please Login or Register  to view this content.

copy down

Seleci I2 and click on black square bottom right of cell

UPDATE:macro added

Please Login or Register  to view this content.

Great answer results.
Thanks to Murry and John for your help.