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