Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Help!
I need help with a formula. Driver schedules are assigned in a spreadsheet with dates on the vertical axis, and each driver's name in a column on the horizontal axis. In the cell for each driver on a certain day, their availability is entered as: D = DAYTIME, E = EVENING, DE= DAY & EVE, X = OFF, V= Vacation, etc.. Also, in a row above the drivers name is entered the word "TOURS" if that driver is able to provide a narrated tour. I need a column that will SUM in each row (each day) the number of drivers that are Available Daytime (D or DE) and are tour qualified ("TOURS" entered above the driver name). Does that make sense? I am currently using the COUNTIF function to count if the driver is available D or DE, but don't know how to check the "Tours" condition. I appreciate your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
COUNTIF - 2 conditions | Excel Worksheet Functions | |||
How can I use COUNTIF to sum for two conditions? | Excel Worksheet Functions | |||
COUNTIF using multiple conditions? | New Users to Excel | |||
setting two conditions for countif | Excel Worksheet Functions | |||
Countif - Countif | Excel Worksheet Functions |