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.