Multiplying different criteria and summing

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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!