Formula Help - Thanks in advance!

[Amy_Winston]

Hi - I'm new at formulas, but is there a formula that could calculate the following based on whether the answer is True or False (Yes or No) for each class?

Role	Number of Users in Role	Class Topic A	Class Topic B	Class Topic C
Clerk	37	TRUE	TRUE	TRUE
Admin	26	FALSE	FALSE	TRUE
Manager	22	TRUE	FALSE	FALSE
Intern	15	TRUE	TRUE	FALSE
Can a formula take the number of people per role and add that total per class if the class column is True?		Total for seats for class A	Total seats for Class B?	Total seats for Class C?

[#2 · Accepted solution]

@Amy_Winston 

See the attached. The formula in Cell C8 is =SUMIF(C2:C5,TRUE,$B$2:$B$5). and that can be copied to the adjacent cells to give the answer for them.

[#3]

Woohoo! Thank you so much! I appreciate it very much.

[#4]

You're very welcome.