Controlling Cells included in a sum command
"Jim Schnur" wrote:
I need to be able to control the cells that are summed by a number
in another cell.
My current sum statement is =SUM (L102,T102,X102,AD102,AJ102).
I need to use the value is cell A1 to indicate how many of the
summed cells to included.
For instance if A1=1 then cell L102 is included in the sum.
If A1=2 then L102 and T102 would be included in the sum.
One way....
Create a table in a range, for example:
X1: =L102
X2: =T102
X3: =X102
X4: =AD102
X5: =AJ102
Then the SUM formula can be:
=SUM(X1:INDEX(X1:X5,A1))
|