Hi all,
Please see my attached image to go along with my question. I'm trying to accomplish this without SUMIFs, as they require another workbook to be open. I am aware of how simply this could be done with SUMIFs, but I would like to do it using SUMPRODUCT or some other method.
I have a set of 1) Available Information in one workbook, which lists sales of products by years.
I have a 2) Mapping of products to product types.
I would like to produce a 3) Final Product that sums up the total sales of product types for each given year.
Is there some way for me to accomplish this using SUMPRODUCTS or another way? I've been racking my brain for hours.
SUMPRODUCT.PNG
Thanks so much!
Edit: added spreadsheet
Bookmarks