How to Add some values in column A based on related values in the same row in column B?

I am a teacher trying to use a formula to add sporting points earned by students if they are in a particular sporting house. The sporting House Column 'B' contains values B or R. The Points earned column contain numbers only.

How do I add all the points earned by students if their House value is B?

I tried the following embedded IF SUM formula:


IF(B2:B11)='B',SUM(L2:L11) but it did not work.


I would like to do this so that any new students entered and given a house will automatically be included in the total point scoring for that sporting house.


Please help.

MacBook Pro (13-inch Mid 2012), iOS 8.3

Posted on Feb 9, 2016 4:41 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to Add some values in column A based on related values in the same row in column B?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.