I'm trying to create formulas for an order form. In column B I have the size
of the product (small, medium, large) and in column C I have "Left" or
"Right". I'd like to write a formula telling me the totals for each: "Small,
left" "small, right" "medium left" "medium right" "large left" large right"
etc. I've tried just about every function that's been suggested for similar
problems and no luck. I've even tried the pivot tables.
Thanks for any input!