sum formula

2.85K viewsFormulas and Functions

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.


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:


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.