SOLVED

New Contributor

# Formula Help - Thanks in advance!

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?
3 Replies
best response confirmed by Amy_Winston (New Contributor)
Solution

# Re: Formula Help - Thanks in advance!

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.

# Re: Formula Help - Thanks in advance!

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

# Re: Formula Help - Thanks in advance!

You're very welcome.