need FORMULA for different qty of columns, MOD?
 

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))

need FORMULA for different qty of columns, MOD?
 

=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))

need FORMULA for different qty of columns, MOD?
 

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))

need FORMULA for different qty of columns, MOD?
 

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))

need FORMULA for different qty of columns, MOD?
 

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.

"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))

need FORMULA for different qty of columns, MOD?
 

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))