Log In
Register
Home
Active Member
January 28, 2022
Offline
I'm working in a forecasting model and need to sum the product of two cells in the same column. The top row is months, and below that is quantity of each product per month, then List price per product (in the exact same order as the quantities), then average selling price per product (in the exact same order as the quantities).
I ultimately need to multiply QTY by List Price with the horizontal criteria of specific product, then vertical criteria of correct month.
Anyone know of a way to do this? I looked up sumproduct function but that only provides the sum of the numbers and not the product of those specific cells.
See AnswerActive Member
January 28, 2022
Offline
I reread what I said and realized without seeing the data it may be hard to visualize. Attachment added
VIP
Trusted Members
December 7, 2016
Offline
Hello,
No file was uploaded. You need to click the Start Upload button after you have added the file, then wait a few seconds for the upload to finish.
Br,
Anders
Active Member
January 28, 2022
Offline
Thank you - file uploaded now.
Trusted Members
Moderators
November 1, 2018
Offline
If they are always in the same order, this would do Pico in E3:
=SUMPRODUCT(--($C$12:$C$119=$D3),E$12:E$119,E$120:E$227)
I'm not clear on whether you are looking for exact matches or partial, or what the criteria for things like 'Accessories and soft goods' would be?
Answers Post
Active Member
January 28, 2022
Offline
Velouria - very helpful! Thank you.
This was a more simplistic version of what I'm trying to do, but I actually have multiple criteria I need to put in. the criteria are in columns next to each other: Product (Pico) then Channel (DTC/AMZ?BTQ etc.)
Is there a way in the Sumproduct to have it exact match the product and channel before performing the rest of the function?
1 Guest(s)
