I am trying to create formulas that coincide with a drop down list.

I have a drop down list that has 5 different options. I want to make sure
that for each option that they each add up seperatley. But also so that when
the same option is chosen more than once, that those all add to the same
place.

For example: working with a drop down list that the options are 1,2,3,4,5
1=1.00
2=1.00
3=1.00
4=1.00
5=1.00
2=1.00
2=1.00

i would like to create 5 seperate formulas (for 1-5) that one will calc all
option 1's, one will cal all option 2's...so on and so forth. You know, just
depending which one the user chooses. I hope this isnt too confusing.
PLEASE HELP!

I don't know what you are trying to calculate - can you give some
further details and clarification?

Pete

On Apr 7, 5:00*pm, reeree5681
wrote:
I am trying to create formulas that coincide with a drop down list. *

I have a drop down list that has 5 different options. *I want to make sure
that for each option that they each add up seperatley. *But also so that when
the same option is chosen more than once, that those all add to the same
place.

For example: working with a drop down list that the options are 1,2,3,4,5
1=1.00
2=1.00
3=1.00
4=1.00
5=1.00
2=1.00
2=1.00

i would like to create 5 seperate formulas (for 1-5) that one will calc all
option 1's, one will cal all option 2's...so on and so forth. *You know, just
depending which one the user chooses. *I hope this isnt too confusing. *
PLEASE HELP!