Sumproduct with a dynamic moving range

[sachindmnc]

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 a mini-sheet below which shows what the result should be like.

Any help is much appreciated. Thanks in Advance.

 

[sachindmnc]

Sumproduct with dynamic moving range.xlsx
	A	B	C	D	E	F	G	H	I
1
2
3
4		Volumes				0	40000	20000	15000
5		%				4%	2%	2%	3%
6		Result				0	1600	1656	1932
Sheet1

Cell Formulas
Range	Formula
F6	F6	= F4 * F5:I5
G6	G6	= G4 * F5:I5 + F4 * G5:I5
H6	H6	= H4 * F5:I5 + G4 * G5:I5 + F4 * H5:I5
I6	I6	= I4 * F5:I5 + H4 * G5:I5 + G4 * H5:I5 + F4 * I5:I5
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sumproduct with a dynamic moving range
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[sachindmnc]

The above question has been Cross posted in the below links as well:

Sumproduct with dynamic moving ranges

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 shared image below which shows what the res...

stackoverflow.com

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...

www.excelforum.com

 

[sachindmnc]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sumproduct with a dynamic moving range
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

Hi Fluff,

Thank you for the reminder.

I provided the Cross posted links.

For XL2BB when I download the file using the link you have share in the post, I'm still getting the 16th January version. Am I looking somewhere wrong?

Please help me for the same.

Thanks in advance

 

[Fluff]

You have the latest version of XL2BB. & thanks for the other link.