Forum Discussion
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...
=COUNTIF($B$4:$D$8,$G4)+COUNTIF($E$4:$E$8,$G4)*2Is this similar to what you are looking for?