Can't remember how to get a Dynamic sum from list.

[mrstrent]

Here is what im trying to figure out.


"PP (3)" is a drop down list.

Once "PP (3)" is changed to "PP (5)" the formula under Total will sum PP (1) to PP (5).


Please help.


PP (3)


ID PP (1) PP (2) PP (3) PP (4) PP (5) Total


1 $1.00 $1.00 $1.00 $1.00 $1.00 3.00

2 $2.00 $2.00 $2.00 $2.00 $2.00 6.00

3 $3.00 $3.00 $3.00 $3.00 $3.00 9.00

4 $4.00 $4.00 $4.00 $4.00 $4.00 12.00

5 $5.00 $5.00 $5.00 $5.00 $5.00 15.00


Thank You,

Mrstrent

 

[Luke M]

Could do:

=SUM(B3:INDEX(B3:F3,MATCH(A1,B2:F2,0)))

Where A1 is the cell with "PP (3)", B2:F2 is your header row, and B3:F3 is the possible range to sum.

 

[mrstrent]

Perfect,


Thank You Luke!

 

[Luke M]

Sweet, glad I could help.