Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- 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 .
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 | |||||||
---|---|---|---|---|---|---|---|
G | H | K | L | AD | |||
1 | ID | Result | TrackCondition | Stake | HorseName | ||
2 | 1 | 0 | Easy | 5000 | Spin Doctor | ||
3 | 2 | 0 | Easy | 25000 | Joe Harry Smith | ||
4 | 3 | 0 | Fast | 5000 | Spin Doctor | ||
5 | 4 | 0 | Heavy | 40000 | Joe Harry Smith | ||
6 | 5 | 0 | Good | 13000 | Spin Doctor | ||
7 | 6 | 13000 | Good | 11000 | Spin Doctor | ||
8 | 7 | 25000 | Easy | 25000 | Joe Harry Smith | ||
9 | 8 | 24000 | Good | 6000 | Spin Doctor | ||
10 | 9 | 0 | Slow | 70000 | Joe Harry Smith | ||
11 | 10 | 30000 | Good | 6000 | Spin Doctor | ||
12 | 11 | 50000 | Easy | 25000 | Joe Harry Smith | ||
13 | 12 | 5000 | Easy | 6000 | Spin Doctor | ||
14 | 13 | 75000 | Easy | 70000 | Joe Harry Smith | ||
15 | 14 | 0 | Good | 50000 | Joe Harry Smith | ||
16 | 15 | 50000 | Good | 25000 | Joe Harry Smith | ||
17 | 16 | 0 | Heavy | 6000 | Spin Doctor | ||
18 | 17 | 75000 | Good | 100000 | Joe Harry Smith | ||
19 | 18 | 11000 | Easy | 25000 | Spin Doctor | ||
20 | 19 | 175000 | Good | 200000 | Joe Harry Smith | ||
21 | 20 | 145000 | Easy | 100000 | Joe Harry Smith | ||
22 | 21 | 0 | Slow | 15000 | Spin Doctor | ||
23 | 21 | 15000 | Slow | 25000 | Spin Doctor | ||
24 | 23 | 70000 | Slow | 15000 | Joe Harry Smith | ||
25 | 24 | 6000 | Heavy | 40000 | Spin Doctor | ||
26 | 25 | 40000 | Slow | 70000 | Spin Doctor | ||
27 | |||||||
Sheet1 |