im trying to get a drop down list and add number in another column, when i
use autosum the numbers add up right, but when i chose one product to check
the numbers, they dont change. the total shown is for all products, how do i
get a total for each individual products in the drop down list?