Ongoing Totals

Hi there

I am hoping someone can help me....I am making a score sheet for the upcoming Sports day at the school where I work and I am a little stuck on the last bit. I basically need to add the ongoing totals for each house team-so when scores are inputted, the house teams score is automatically being added up.....I think I would need to mail someone the sheet to show how far I have got as I dont think it is a simple count formula....anyone help?
Thanks in advance!

Welcome to the board !
you can attach a zipped sample file if you want

Hi there
Thanks for that, have uploaded now...

I think you may see what I am needing to do....
In columns G, H, I and J .....I need to add the ongoing total under each house - so needs to pick up from column c for the house name and then column E for the points...does that make sense? hard to put into words, but think you will see what I mean!
Thank you!

Great!

Thank you so very much indeed! Just what I needed!

Also, sorry to be a pest - but is there a way that when the scorer types in say "1" for the placing that the points column automatically puts in an "8" and so on.....relating to the scoring information chart - eg if pupil comes 2nd, they get 7 points...etc etc...
Just trying to make it easier for the teacher inputting the scores on the day...you know how lazy teachers are! hehe

Thanks again!

Hi,

Put this in E4 and copy down

=LOOKUP(D4,{1,2,3,4,5,6,7,8},{8,7,6,5,4,3,2,1})

Ed

MAGIC!

Thanks for that! Perfect, what an easy task the teachers will have inputting the data now....

Thanks all!

oops, just seen though that it messes the forumla up in the ongoing totals....any suggestions?

Hi Hannah,

Put this in G4 and copy across

=SUMIF($C$4:$C$100,G3,$E$4:$E$100)

Ed

Hi Hannah,

To tidy it up, put this amended formula in E4 and copy down

=IF(D4="","",LOOKUP(D4,{1,2,3,4,5,6,7,8},{8,7,6,5,4,3,2,1}))

Ed

thanks!

all works except for MacArthur column in cell I4
?

silly me, was a small glitch on my sheet....all works now...fab! thanks so much!

This cell should contain

=SUMIF($C$4:$C$100,I3,$E$4:$E$100)

It works for me

Ed

Glad to see you got it sorted - thanks for the feedback