need FORMULA for different qty of columns, MOD?

[Nastech]

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)),$AC9:$AK9))

 

[Bob Phillips]

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

--
HTH

Bob

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

 

[Nastech]

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]

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]

hi, thanks! that seems to work great. didn't know you were still there,
started looking at that long time ago; maybe didn't know how to ask, thought
would take asking in at least 2 parts as was... will post copy in other
string in case anyone see's question there/ wanted to know. thanks again.

 

[Nastech]

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

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