sum formula

2.85K viewsFormulas and Functions
0

Anybody knows how to create a sum-formula getting the results of various month according to the month entered in an assumtion matrix. For example, I would like to sum the month of Jan to May to compare with the same month of the previous/plan month. An example is attached.

0

Hello – thank you for posting.

I think the use of the INDIRECT function would be of use here. You can learn more about INDIRECT by reviewing this modeler note:

[url:x84hxiys]http://www.quantrix.com/r-doc-4-15-101[/url:x84hxiys]

And I have also attached your model file with the INDIRECT function implemented to get you started.

INDIRECT allows you to use variables in another matrix to control a formula.

Check it out and please post again if any further questions arise.

-Mike