How do I make Excel count 2 for certain people and 1 for others?

Copper Contributor

I have an excel spreadsheet that I use for staffing. It totals the number of days, nights, weekends, etc that everyone is working. Now I have added another column that totals transport shifts. I need to make it so 

when I type in someone's name for transport, the formula will count it and return 2 instead of 1 for their name.  When people are working 12 hour shifts it returns 1. When they are listed in the transport section (a 24 hour shift) I need to to count it as 2 shifts without adding heir name another time. How do I do that?



Sherilyn Kelly

1 Reply



Is this similar to what you are looking for?