Hello. I have categories of quantity and price for 10 items and I would like to figure out what the yearly total is for all the items. I think I could do a sumproduct but maybe a pivottable would work too. Spreadsheet attached. The parts I need formulas for are in yellow. Thanks.
Bookmarks