Count the number of names in 3 columns depending on the Customer column
Please help me with a formula to count the number of technician names in 3 columns (Lead, Support, LOTO) depending on name in the Customer Column.
I need to see the number of techs assigned to Vestas, and the number techs assigned to EDF. I want to count the entire column though, since there are more than two customers. I understand I may need a different formula for each customer.
For Vestas, total should be 11
For EDF, total should be 6
Help Article Resources
Check out the Formula Handbook template!