Below is a schedule...the Top half has the hours in A5:A24, a full months
schedule from B$5:AC$24. Within this area lists the name of the person
working. The second half of this form lists each person and how many shifts
they are working within the week. These cells have a formula, example
=COUNTIF(C$5:C$24,$A27) answers true 1 and false 0. I need this answer to
change if true to reference the first columns hours instead. I've tried a
million possiblities this week...what am I missing? I've tried IF, VLOOKUP,
INDEX, TEXT, #VALUE #REF, LOOKUP, MATCH. I've even tried to switch it
around, in the value 1 box, SEARCH for the Name from C5:C24 to A5:A24. It's
not working...THANK YOU FOR YOUR HELP!!! Please advise. Karen

Hours Sunday Monday Tuesday Wed
8/30/2009 8/31/2009 9/1/2009 9/2/2009
7A Rondeau McNichols McNichols McNichols
7A Jenkes Casavant
7A-C Labonte Bergeron Chiarini DiSandro
7A-C DiSandro Labonte
8A Machado Chiarini Sousa Cairone
8A Pereira Pereira
9A Baughan Colombier Jenkes
9A Vaughan Lawson McKinnon
11A Sousa Baughan Baughan
11A Trainor Machado Houle
3P Ferri Ferri Ferri Beaudreau
3P Rondeau Howard Perry Machado
3P-C Beaudreau Beaudreau DiSandro
3P-C Snowling Snowling
4P Houle White Sousa Campbell
4P Machado Rondeau Morrison Pereira
11P Ferri Howard Ferri Beaudreau
11P White McKinnon Perry Howard
11P-C DiSandro DeCesare Bergeron Perry
11P-C Snowling DiSandro Snowling

Shift/Week
Baughan 0 1 1 1
Beaudreau 0 1 1 2
Bergeron 0 1 1 0
Cairone 0 0 0 1
Campbell 0 0 0 1
Carnes 0 0 0 0
Casavant 0 0 0 1