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!
Bookmarks