Automated range selection
 

Hi

I have a multiple rows containg IF fuctions,

`=IF(E11=1,"Promotion Start Date",IF(E11F11," Promotion End Date ",
"))

in another row I have `=IF(E280,D11+1,0).


What I try to acieve is the folowing

Day 1 2 3 4 5

Start Date is day 1 and end date is day 5

PROMO START DATE ( Blank Cell) (BlankCell) (BlankCell) PROMO END DAT


Count the cells, then with a lookup, go to same range of cells, with
differant row number, altought the coloms is staying the same and su
the range in the new row.

I will have 10 promotions a year, not overlaping, but all will be o
the same sheet. So there will be multiple ranges, and that is why onl
want the range between start and end date to o be summed.

Please help


thie

--
Thie
-----------------------------------------------------------------------
Thiem's Profile: http://www.excelforum.com/member.php...fo&userid=2747
View this thread: http://www.excelforum.com/showthread.php?threadid=47140