Sumproduct with a dynamic moving range
Hi Guys,
I have been trying to get results from SUMPRODUCT based on the data for volumes and %s which need to change every year but so far have no success.
I have attached an image and a file below which shows what the result should be like.
Any help is much appreciated. Thanks in Advance.
Sumproduct with Dynamic moving range.jpg
Sumproduct with dynamic moving range.xlsx
Administrative Note:
Welcome to the forum.
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.
Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.
New users may not post live links. You may include the URL without the "https://" portion.
(Note: this requirement is not optional. No help to be offered until the link is provided.)
Hi 6StringJazzer,
Thank you for bringing this to my attention.
Below are links to the forums to which I have cross posted this to:
stackoverflow.com/questions/66580046/sumproduct-with-dynamic-moving-ranges
mrexcel.com/board/threads/sumproduct-with-a-dynamic-moving-range.1164539/
Hi 6StringJazzer,
Thank you for bringing this to my attaention.
I have posted the cross posted links in the thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks