Hi, was wondering if there is a shorter version: have %change equation, that
adds a cummulative of %change for each day, but do not know how to
abbreviate. (must keep original amounts in each column to show direction
up/dn)

(adding separate amounts for each day, for each range selected, such as:
2=(day1+day2),3=(day1+day2+day3)... (thanks)

long verson:
=IF(OR(BS9="",COUNTA(BT9:BX9)=0,MIN(BT9:BX9)=MAX(B T9:BX9)),"",
IF(OR($BH$2={"",".",2}),(BS9/BT9%-100)+(BT9/BU9%-100),IF($BH$2=3,(BS9/BT9%-100)+(BT9/BU9%-100)+(BU9/BV9%-100),
IF($BH$2=4,(BS9/BT9%-100)+(BT9/BU9%-100)+(BU9/BV9%-100)+(BV9/BW9%-100),
IF($BH$2=5,(BS9/BT9%-100)+(BT9/BU9%-100)+(BU9/BV9%-100)+(BV9/BW9%-100)+(BW9/BX9%-100))))))