Hi, i'm really new at excel and I have this so far. Capture.JPG

The highlighted 'a's are dropdown lists that go from a through e.

I need help making sure the totals, (which have sum formulas) add separately for each a,b,c,d, and e. Is that possible?

Like if I go from A to B, the cells return to zero and only add for b.

thank you!