Dear all,
I require a dynamic cell range within the SUMPRODUCT/SUMIF formula so that I can sum up the sales for a product if it is defined both individually and within a portfolio (Adidas) and Portfolio (Adidas/Nike) within the calculation table.
=SUMPRODUCT(SUMIF(D:D,H4:H5,E:E))
As shown in the screenshot, H4:H5 comes from the Product-Portfolio table and the range is defined based on the Portfolio Name.
Can anyone advise on this?
Thanks!
Capture1.JPG
Bookmarks