LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Doodlemeyer
 
Posts: n/a
Default 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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF - 2 conditions Doodlemeyer Excel Worksheet Functions 1 March 17th 05 02:49 PM
How can I use COUNTIF to sum for two conditions? Jeff Excel Worksheet Functions 4 December 30th 04 05:25 AM
COUNTIF using multiple conditions? Muse of Fire New Users to Excel 3 December 29th 04 08:49 PM
setting two conditions for countif Danny J Excel Worksheet Functions 5 December 6th 04 11:49 PM
Countif - Countif maswinney Excel Worksheet Functions 3 November 15th 04 11:06 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"