MOD Columns / INDIRECT.. for x3 columns?

[Nastech]

hi, trying to be able to modify a formula, to pick the number of columns
desired for a calculation. examples below are for 3 columns, would range
from 2-10 columns.

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

is a percent change formula: fm/to%-100
got some help with:

=IF(K9=0,"",SUMPRODUCT(ED9:EF9/EE9:EG9%-100))

would I use INDIRECT, MOD.. think would prefer a multplication? for
external entry in one fixed cell, e.g.: 3 (as above). thanks

 

[Bob Phillips]

See my reply in your original thread.

--
HTH

Bob

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

 

[Nastech]

answer works for:

SUMPRODUCT(ED9:INDEX(ED9:EM9,1,$DJ$6)/EE9:INDEX(EE9:EN9,1,$DJ$6)%-100)

 

[Nastech]

in case anyone wanted to know, this is the formula 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))