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

New 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?

 

Thanks,

Sherilyn Kelly

1 Reply

@sherilynk 

=COUNTIF($B$4:$D$8,$G4)+COUNTIF($E$4:$E$8,$G4)*2

Is this similar to what you are looking for?

transport.JPG