Controlling Cells included in a sum command

J

Jim Schnur

Hi,

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.
Any help would be greatly appreciated.
 
J

joeu2004

Jim Schnur said:
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))
 
K

Kevin@Radstock

Hi

Maybe using a IF function could be one option
=IF(A1=1,SUM(L102),IF(A1=2,SUM(L102,T102),IF(A1=3,SUM(L102,T102,X102),IF(A1=4,SUM(L102,T102,X102,AD102),IF(A1=5,SUM(L102,T102,X102,AD102,AJ102)))))
 
J

Jim Schnur

'joeu2004[_2_ said:
;1608058']"Jim Schnur said:
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))

Thank you......
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top