Help!

I need help with a formula.

Driver schedules are assigned with D = DAYTIME, E = EVENING, X = OFF, V=
Vacation.

(Driver Frank is available Monday DE , Jerry is Off)

The green column should be the sum of all drivers that are available Daytime
(D or DE) and also if they are qualified to do Tours (check for TOURS in the
rows above). Frank Danny Jerry and SMitty are Tour Qualified. Doug is NOT.

The number in the Green column for Monday should be 2 (Frank and Danny).

Thanks!



Training Level: 3 3 3 3 3 Available Drivers
Driver Schedule as of Jan 1st, 2005 DO NOT DELETE DRIVER NAMES Frank
Doug Danny Jerry K. Smitty Date DAY EVE Tour Drivers Available
BUS 723 717 719
ROYAL ROYAL ROYAL ROYAL ROYAL
QC QC QC QC QC
TOURS TOURS TOURS TOURS
Monday 13-Mar-05 DE DE DE X V 13-Mar-05 3 3
Tuesday 14-Mar-05 DE V DE DE X 14-Mar-05 3 3
Wednesday 15-Mar-05 DE X DE DE X 15-Mar-05 3 3