I am trying to add a formula to a schudule spread sheet that will allow
me to input dates of different events happening in town, and how many
people are expected to be at each event, then for each day give me a
total number of potential people in town.

For example:
Cells B4:B11 = days of the week (7/4 - 7/10)

Cells B12 and B13 = Start date and end date of event (conventions
etc.)

Cell B14 = Number of people at event.

I would like to have Cell A4:A11 contain the number of people in town.

If I only have one event in town, this is easy, but where I am running
into a problem is when there is more than one convention in town, and
with different begin and end dates.

For example:

B12 = 7/4, B13 = 7/10, B14 = 1000
C12 = 7/4, C13 = 7/5, C14 = 1000

I would like for Cell A4 and A5 to both show 2000 (total number of
people in town for event) but A6 thru A11 to show 1000 ( first
convention ended, second still going)

Can anybody give me a hint as to how to make this work?

Thanks in advance.

Darron


--
djeans
------------------------------------------------------------------------
djeans's Profile: http://www.excelforum.com/member.php...fo&userid=1401
View this thread: http://www.excelforum.com/showthread...hreadid=384089