Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOD Columns / INDIRECT.. for x3 columns?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOD Columns / INDIRECT.. for x3 columns?
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" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOD Columns / INDIRECT.. for x3 columns?
answer works for:
SUMPRODUCT(ED9:INDEX(ED9:EM9,1,$DJ$6)/EE9:INDEX(EE9:EN9,1,$DJ$6)%-100) "Nastech" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
MOD Columns / INDIRECT.. for x3 columns?
in case anyone wanted to know, this is the formula 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)) "Nastech" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Looking at several columns with Indirect | Excel Worksheet Functions |