Forum Discussion
Solved
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? |
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 Replies
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.
- Woohoo! Thank you so much! I appreciate it very much.
- You're very welcome.
