Prev: Pivot Table Pareto Chart ... How?
Next: Excel 2007 table formatting
From: Ken on 3 Feb 2010 16:14
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!

 | 
Pages: 1
Prev: Pivot Table Pareto Chart ... How?
Next: Excel 2007 table formatting