sum formula

[mustu2]

Hi

Thanks for reading the post.

I have a range of column; A, B, C
Input Data:1/2/3

i want a sum formula in Col D which if i change my input data it adds the number.

Say Input Data: 2, the formula in Col D should add Col A+Col B

Thanks

 

[T. Valko]

Hi

Thanks for reading the post.

I have a range of column; A, B, C
Input Data:1/2/3

i want a sum formula in Col D which if i change my input data it adds the number.

Say Input Data: 2, the formula in Col D should add Col A+Col B

Thanks

Try this...

Data in the range A2:C10.

E2 = input value, either 1, 2 or 3

=SUM(A2:A10:INDEX(A2:C10,0,E2))

If E2 is an empty cell the formula will calculate the ENTIRE range.

 

[mustu2]

thanks a lot!

 

[T. Valko]

Try this...

Data in the range A2:C10.

E2 = input value, either 1, 2 or 3

=SUM(A2:A10:INDEX(A2:C10,0,E2))

If E2 is an empty cell the formula will calculate the ENTIRE range.

Slight tweak that saves a couple of keystrokes...

=SUM(A2:INDEX(A2:C10,0,E2))

 

[T. Valko]

thanks a lot!

You're welcome!