Tech Support Guy banner
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
8 Posts
Discussion Starter · #1 ·
Here is my challenge.

I have a table representing Demand employees on various dates for "AM" shifts, and "PM" shifts.

23/1/10 24/1/10 25/1/10 26/1/10 27/1/10
Demand AM 5 5 5 5 15
Demand PM 5 5 5 5 15

Below this I have a list of names followed by the shift they are working, and the date.

Volunteer Name Shift Shift Date
Frank PM 23/01/2010
Allice AM 24/01/2010
Brandon PM 25/01/2010
Craig AM 26/01/2010

What I need is a formula that will subtract 1 from the demand total of either Demand AM or Demand PM when "AM" or "PM" is entered in these cells corresponding to the date. Any ideas? Help me!
 

Attachments

1 - 1 of 1 Posts
Status
Not open for further replies.
Top