Nested "IF" problem

[Alby]

Help!
I have 4 columns that have 12 rows of data. the 12th row
is the sum of each column.

1 2 3 4
sum 234 367 666 1098

What I'm trying to achieve is:
If a certain cell contains a 1 then another cell =234
If it contains a 2 then the other = 234+367 = 601
If it contains a 3 then the other = 234+367+666 = 1267

The sum in each column is also variable.

Thanks in advance

 

[Don Guillett]

something like this?

What I'm trying to achieve is:
If a certain cell contains a 1 then another cell =234
If it contains a 2 then the other = 234+367 = 601
If it contains a 3 then the other = 234+367+666 = 1267

=choose(yourcell,a1,a1+b1,a1+b1+c1)