Hi

I have a multiple rows containg IF fuctions,

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

in another row I have `=IF(E28>0,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 DATE

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

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

Please help


thiem