Adding a total up as i go week to week!

Hi all im new to all this excel stuff (newbie )
I want to track my weekly football points, is there a way that it will add up for me as i input a number week after week in the total column?

Any help would be great, Thank you.

Lee

Hi, welcome to the forum.

In C11 enter

Formula:

Please Login or Register  to view this content.

then drag this formula down the column as far as you need (select C11, move your mouse to the bottom right until your cursor becomes a cross then left-click and drag down).

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

@FDibbins:
Good point - I assumed having the same total all the way down would be ok, but the IF/"" makes it much tidier-looking.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.

Hi,

Thank you so much! it works a treat, quick response too!
So glad i have found this forum.

Lee,

You're welcome - glad we could help and thanks for the rep.

Regards,
Aardigspook

If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark Thread as Solved'.
You don't need to give me rep if I helped, but thanks are appreciated.