Nested "IF" problem

  • Thread starter Thread starter Alby
  • Start date Start date
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
 
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)
 
Back
Top