COUNTIF with two conditions

[Doodlemeyer]

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!

 

[Don Guillett]

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

 

[Aladin Akyurek]

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"))