Accumlated points total (looking at text)

hello All

I would like sum figure the red cell, the figure needs to work out how many point have been accumulated
I need the formula to look at see if wolves are at Home or away and then work out how many points would be earned from the prediction

Wolves beat Everton 3 Points
Wolves beat Leicester 3 Points
Wolves bet west ham 3 Points
Wolves Draw to Burnley 1 Point

Wolves win = 3 Points
Wolves Loss = 0 Points
Wolves draw = 1 point

Blue Cell = is the actual result that will be entered through the season, Formula to work out how many points have been earned

you could use below in blue cell

Formula:

=SUMPRODUCT((C9:C46="Wolves")*(H9:H46="home")*3+(C9:C46="Wolves")*(H9:H46="draw")*1)

change the "Wolves" to your requirement or type Wolves in a cell and refer the cell in formula to make it dynamic

Hello

i can't get that to work ?

3 points are awareded when Wolves score is greater than the oppenents

use below

Formula:

=SUMPRODUCT((TRIM(C9:C46)="Wolves")*(D9:D46>F9:F46)*3)+SUMPRODUCT((ISNUMBER(D9:D46)*(TRIM(C9:C46)="Wolves")*(H9:H46="Draw")*1))

there are spaces also after the wolves thus trim is used to override that and for wolves score will be 7 not 10 in your sheet

i must be doing something totally stupid, as i cant get this to work

I've opened up your workbook to try and figure out what you are after here, but it's not completely making sense. I feel like your original explanation above is only clouding the issue. In your workbook, cell AS12, you have a comment that the correct score should be 15 points. Why is that? The prediction is 3 goals out for both the home and away team, so it would make sense that the score is 9 (15-3-3). If it should be 15, please explain why. A better explanation of the scoring calculations and a couple of clear examples would be very helpful. Then, I can help you get the result you want. Thanks!