How to reference a dynamic array

Hi,

I'm trying to use a series of lookup and index functions to divide one product's monthly sales by the sales of all products in a given month. The trick is to have both the numerator (the individual product sales) and the denominator (the array of all product sales) shift over time by updating just the month name. Please let me know what is wrong with my formula starting in cell R5 for achieving this!

Thanks in advance, and I've uploaded a sample file of what I'm trying to do!

Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Removed by FR: Posted before refreshing warning.

Thanks for changing the title.

ReportMonth =Sheet1!$D$4:INDEX(Sheet1!$4:$4,,COUNT(Sheet1!$4:$4)+3)
SalesData =Sheet1!$D$5:INDEX(Sheet1!$1:$1048576,COUNTA(Sheet1!$C:$C)+4,COUNT(ReportMonth)+3)
M6:

Please Login or Register  to view this content.