Sum some cells in a row based on condition of nearby cells in same row

Basicalley I have a series of columns, each 5 letters together represent an order(a,b,c,d,e), the columns are repeated approximately 15 times, similar to the following;

Bag Size: B/G 5lb 2lb 16oz 8oz B/G 5lb 2lb (repeat...)

Catagory 1 A B C D E A1 B1 C1 (repeat...)
Catagory 2 AA BB CC DD EE AA1 BB1 CC1 (repeat...)
(...Repeat)


The B/G stands for Whole Bean, or Ground, the A's are drop down lists giving those 2 options, the other cells (non-A's) are all numeric. At the end of each row, the orders need to be summed up into categories; 5lb whole, 5lb ground, 2lbs whole, 2lbs ground, 16 whole, 16 ground etc..

I am looking for a way to sum each category for all orders as necessary, in one cell adding all B's (in that row for that catagory) if its corresponding A is whole bean, in the next summing all b's if its corresponding A is Ground. The same will go for the C's D's and E's.

Thank you very much if anyone can figure this out...

The formatting didn't come out as expected, but the column B/G is the A's , the 5lb is the B's, 2lb C's, 16oz D's, 8oz E's.