Multiplying different criteria and summing

TimJL
✭✭
Good Afternoon,
Another challenge I can't quite to conquer:
Here is the formula that works: =COUNTIFS({Emp Status}, [Emp Status]@row, {Rank}, ="OFC") * 4
I want to add other Ranks and combine all the totals: CPL/DET *4, LT *10, CMDR *12, AC *12, COS *12, Chief *12
If anyone has suggestions.
Best Answer
-
You would do a separate COUNTIFS for each one, do the appropriate multiplication, then add them all together.
=COUNTIFS(..........) * 4 + COUNTIFS(..........) * 10
Answers
-
You would do a separate COUNTIFS for each one, do the appropriate multiplication, then add them all together.
=COUNTIFS(..........) * 4 + COUNTIFS(..........) * 10
-
Thanks! Took a little doing with putting in all the references....but it worked! THanks!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!