Aug 10 2022 03:31 PM - edited Aug 10 2022 03:32 PM
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? |
Aug 10 2022 05:06 PM
Solution
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.
Aug 10 2022 05:07 PM
Aug 10 2022 05:06 PM
Solution
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.