Hi All,
I'm looking for a formula to add house points together. The houses (Blue, Gold, Green, Red) will needed to be added separately and shown in B47, C47, D47, E47.
The house points total will come from adding the numbers in cells E5:41+G5:G41+I5:I41+K5:K41+M5:M41+O5:O41+Q5:Q41
So basically I don't know how to write a formula that only adds the scores from the students in 'BLUE' house and shows the total in B47. The same with all three other houses.
Any help is appreciated!
Thank you!
Bookmarks