Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
refer to whole column
Hi!
How do I refer to a whole column by a number of a cell? For example, if a number of a certain cell is 1, then the column will be A:A. If a number of a cell is 3, the column will be C:C. I will be using the result as the [Sum_Range] in a SUMIF function. Thank you very much! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
refer to whole column
=sumif(x:x,"xxx",indirect("C"&z999,false))
Where x:x contains the value you want to compare. And z999 contains the column number Ken wrote: Hi! How do I refer to a whole column by a number of a cell? For example, if a number of a certain cell is 1, then the column will be A:A. If a number of a cell is 3, the column will be C:C. I will be using the result as the [Sum_Range] in a SUMIF function. Thank you very much! -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
refer to whole column
You can do this without indirect. You can use index instead something like
this. The advantage is that index is not volatile saving the overhead of recalculating. =sumif(x:x,"xxx",INDEX(B:Z,,A1)) Where A1 contains the column number. -- HTH... Jim Thomlinson "Dave Peterson" wrote: =sumif(x:x,"xxx",indirect("C"&z999,false)) Where x:x contains the value you want to compare. And z999 contains the column number Ken wrote: Hi! How do I refer to a whole column by a number of a cell? For example, if a number of a certain cell is 1, then the column will be A:A. If a number of a cell is 3, the column will be C:C. I will be using the result as the [Sum_Range] in a SUMIF function. Thank you very much! -- Dave Peterson . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I refer to an entire column? | New Users to Excel | |||
Refer to column width in conditional formatting | Excel Discussion (Misc queries) | |||
Countif forumulas that refer to more than one column | Excel Worksheet Functions | |||
How to refer to current column in a formula? | Excel Discussion (Misc queries) | |||
Trying to get a column of numbers to refer back | Excel Worksheet Functions |