Nested "IF" problem

A

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
 
D

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
Click to expand...

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