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,AD1 02),IF(A1=5,SUM(L102,T102,X102,AD102,AJ102))))))
Quote:
Originally Posted by 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.
|