Sum previous stakes by name and condition .

Sunline

Well-known Member
Joined
Oct 6, 2007
Messages
701
Office Version
  1. 2016
Platform
  1. Windows
Hello all,

I am hoping to get a function that can give me the results I have in col H .

Col AD there are two horses.
Each may of run in col K different track conditions .

I want to sum the previous stakes by firstly col AD horse name , then track condition ,
then sum stakes giving final result in col H .

Joe Harry Smith in Easy (col K) has earned $145,000 in 5 starts .
On his 6th start in Easy result will be $245,000 .

Have not been able to get this function to work on thousands of horses .
=SUMIF($K$2:$K2,K2,$L$2:$L$2)-L2

Many thanks .
Excel Workbook
GHKLAD
1IDResultTrackConditionStakeHorseName
210Easy5000Spin Doctor
320Easy25000Joe Harry Smith
430Fast5000Spin Doctor
540Heavy40000Joe Harry Smith
650Good13000Spin Doctor
7613000Good11000Spin Doctor
8725000Easy25000Joe Harry Smith
9824000Good6000Spin Doctor
1090Slow70000Joe Harry Smith
111030000Good6000Spin Doctor
121150000Easy25000Joe Harry Smith
13125000Easy6000Spin Doctor
141375000Easy70000Joe Harry Smith
15140Good50000Joe Harry Smith
161550000Good25000Joe Harry Smith
17160Heavy6000Spin Doctor
181775000Good100000Joe Harry Smith
191811000Easy25000Spin Doctor
2019175000Good200000Joe Harry Smith
2120145000Easy100000Joe Harry Smith
22210Slow15000Spin Doctor
232115000Slow25000Spin Doctor
242370000Slow15000Joe Harry Smith
25246000Heavy40000Spin Doctor
262540000Slow70000Spin Doctor
27
Sheet1
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.
Thanks for that answer it works perfectly .

Just posted another table .
Is it possible to get my results in col H using Averageifs .

Thanks .
Excel Workbook
GHKADAH
1IDResultTrackConditionHorseNameFinish
210EasySpin Doctor9
320EasyJoe Harry Smith3
430FastSpin Doctor1
540HeavyJoe Harry Smith1
650GoodSpin Doctor9
769GoodSpin Doctor5
873EasyJoe Harry Smith1
987GoodSpin Doctor2
1090SlowJoe Harry Smith14
11105.3GoodSpin Doctor8
12112EasyJoe Harry Smith1
13129EasySpin Doctor3
14131.6EasyJoe Harry Smith5
15140GoodJoe Harry Smith11
161511GoodJoe Harry Smith1
17160HeavySpin Doctor6
18176GoodJoe Harry Smith12
19186EasySpin Doctor7
20198GoodJoe Harry Smith3
21202.5EasyJoe Harry Smith11
22210SlowSpin Doctor4
23214SlowSpin Doctor1
242314SlowJoe Harry Smith3
25246HeavySpin Doctor1
26252.5SlowSpin Doctor14
Sheet1
 
Upvote 0

Forum statistics

Threads
1,213,510
Messages
6,114,048
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top