=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!