Hi,
I'll try explain this as best i can.
This spread sheet is for a football game.
if you score a goal you get 5 points / assist a goal 3 points / yellow card
I start in cell c as A and B have names.
In C i have goals - If enter 1 in C2 you will get 5 points. But if i enter 1 in E2 ( yellow card ) you get a minus 1. So your 5 + -1 is 4..
The trouble i have is adding all these in the total box.
If someone has 2 goals / 1 assists / 1 yellow card there total should be 12 but it's not working for me.
Is it the sum im using =SUM(C2*5+D2*3+E2-1+F2-3+G2+H2)
I need to add part one.. then part 2 then part 3 etc and then add or minus them from each other.. how can i do this in 1 sum ?
thanks.
Bookmarks