Forum Discussion
Amy_Winston
Aug 10, 2022Copper 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 T...
- Aug 11, 2022
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
Aug 11, 2022Gold Contributor
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.
Amy_Winston
Aug 11, 2022Copper Contributor
Woohoo! Thank you so much! I appreciate it very much.
- mathetesAug 11, 2022Gold ContributorYou're very welcome.