Combo box formula - how do i include it ?

  • Thread starter Thread starter Fredy
  • Start date Start date
F

Fredy

I'm trying to figure out a formula for the following. I
have an order form where certain products are classified
as one of two categories. THe two categories exist in a
combo box control (not userform or vba). I want o add up
the category total for cat1 and total for cat 2 items and
based on the sums, calculate a delivery and install fee.
Basically, if i have this much worth of cat1 items, charge
this much D&I, if ihave this much, then.........and so
forth. I have everything except how to include the combo
box in the formula. Can anyone help?

thanks,
 
Fredy

The problem with a combo box is that you have to get the
value from a linked cell. This will give a value of either
1 or 2 for two categories.

The answer is to convert them back into Text. My test
linked cell was in J1. In L1 I used this formula
=IF(J1=1,"A","B") which converts is back to text.

My Test data is in the range A6 to B12
Cat Qty
A 1
A 1
B 2
B 2
A 1
A 1

Formula to calc list is =SUMIF(A7:A12,L1,B7:B12)

Try this out and then adapt it for your own needs.

Regards
Peter
 
Back
Top