in case anyone wanted to know, this is what am using:

=IF(OR(COUNTIF(EE9:EN9,{"",0}),MIN(EE9:EN9)=MAX(EE 9:EN9)),"",
SUMPRODUCT(ED9:INDEX(ED9:EM9,1,$DJ$6)/EE9:INDEX(EE9:EN9,1,$DJ$6)%-100))

"Bob Phillips" wrote:

Can't you just extend the range to 10 columns, or perhaps you could put the
column count in EH1 and use

=SUMPRODUCT(ED9:INDEX(ED9:EZ9,1,EH1)/EE9:INDEX(EE9:FA9,1,H1)%-100)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nastech" wrote in message
...
hi, thanks.. did not realize that part would be that simple.
is there a way to externalize the 2nd part of the range?
the example used keys on 3 columns, this formula
will allow me to use all 10 columns that I have.
will look at INDIRECT but am trying to move
value for EF - EG to a single cell. thanks.

"Bob Phillips" wrote:

=SUMPRODUCT(ED9:EF9/EE9:EG9%-100)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Nastech" wrote in message
...
hi, have a formula where calculate on a different range of columns,
looking
for a way to modify that number, the following using set of 3.

=IF(K9=0,"",((ED9/EE9%)+(EE9/EF9%)+(EF9/EG9%))-300)

is there a way to use MOD.. or other on it to shorten / make
adjustable?
thanks.
formula for calculating percent change: fm/to%-100

have following example for adding every other column.

=IF(AC9="","",SUM(--(MOD(COLUMN($AC9:$AK9),2)MOD(COLUMN($AC9),2)),$AC 9:$AK9))