Forum Discussion
sherilynk
Jul 21, 2022Copper Contributor
How do I make Excel count 2 for certain people and 1 for others?
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?
Thanks,
Sherilyn Kelly
1 Reply
- OliverScheurichGold Contributor
=COUNTIF($B$4:$D$8,$G4)+COUNTIF($E$4:$E$8,$G4)*2
Is this similar to what you are looking for?