A B C D
E F
Item No. Units Ordered 1-9 10-19 20-30+ Total
JABDBOM1106 _________ $37.46 $34.44 $32.11 ______
JABDBOM1109 _________ $37.46 $34.44 $32.11 ______
JABDBOM0111NG _________ $52.65 $48.40 $45.13 ______
JABDBOM0113NG _________ $52.65 $48.40 $45.13 ______
JABDBOM1206 _________ $37.46 $34.44 $32.11 ______

What I am trying to accomplish is when I enter a number inot the "Units
Ordered" column (B2:B6), based on the columns C,D,&E, I want the total to
relfect the total amount of $ based on the Units ordered and taking the
information from the correct column. I hope this explains better what I am
trying to accomplish. Thanks to anyone that can help.