COUNTIF with two conditions
 

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!

=sumproduct((a2:a22="cond one")*(b2:b22=1)*1)

--
Don Guillett
SalesAid Software

"Doodlemeyer" wrote in message
...
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!

Let B2:K2 house the TOURS qualification when appropriate.
Let B3:K3 house drivers (names).
Let B4:K4 house the availability markers.

In L4 enter & copy down:

=SUMPRODUCT(--ISNUMBER(MATCH(B4:K4,{"D","DE"},0)),--($B$2:$K$2="TOURS"))

Doodlemeyer wrote:
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!