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!