G
Guest
Hi
I wish to sum a list of numbers with one of them being a combobox. The list
is 42,500 + 332,500 + 532,000 + 212,800 + 30,500 with the fourth one being a
combobox with values in it of 90,000 to 110,000. What I want is everytime you
change the value in the combobox the Total formula wil recalculate to the new
total? I have so far =sum(e4:e9). How do I put the combobox in the formula
=sum(e4:e9).
Thanks
John
I wish to sum a list of numbers with one of them being a combobox. The list
is 42,500 + 332,500 + 532,000 + 212,800 + 30,500 with the fourth one being a
combobox with values in it of 90,000 to 110,000. What I want is everytime you
change the value in the combobox the Total formula wil recalculate to the new
total? I have so far =sum(e4:e9). How do I put the combobox in the formula
=sum(e4:e9).
Thanks
John