SOLVED

Formula Help - Thanks in advance!

New Contributor

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?

RoleNumber of Users in RoleClass Topic AClass Topic BClass Topic C
Clerk37TRUETRUETRUE
Admin26FALSEFALSETRUE
Manager22TRUEFALSEFALSE
Intern15TRUETRUEFALSE
     
     
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 ATotal seats for Class B?Total seats for Class C?
3 Replies
best response confirmed by Amy_Winston (New Contributor)
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.

 

mathetes_0-1660176289692.png

 

Woohoo! Thank you so much! I appreciate it very much.
You're very welcome.