scrivolenski
New Member
- Joined
- Jul 6, 2011
- Messages
- 1
Hi.
I'm struggling to find a solution to a problem I have so am first time posting on this forum.
I have 4 worksheets containing customer sales volume data (each sheet is a different forecast ie. budget 1, budget 2, budget 3, actual) with the key field being the customer number. Customer numbers are listed vertically and the months are listed horizontally.
I have created a dynamic report using vlookups which if I select a month number it will return the correct months data per customer from all 4 sheets in 4 columns based on column numbers. However I now want to complete a year to date report in the same manner. ie. If I select month 6 I want the report to return the total cumulative sales for the first 6 months.
How can I do this? I am looking for a dynamic horizontal sumif if that makes sense where I can set the number of columns to sum across based on the month number.
I'm struggling to find a solution to a problem I have so am first time posting on this forum.
I have 4 worksheets containing customer sales volume data (each sheet is a different forecast ie. budget 1, budget 2, budget 3, actual) with the key field being the customer number. Customer numbers are listed vertically and the months are listed horizontally.
I have created a dynamic report using vlookups which if I select a month number it will return the correct months data per customer from all 4 sheets in 4 columns based on column numbers. However I now want to complete a year to date report in the same manner. ie. If I select month 6 I want the report to return the total cumulative sales for the first 6 months.
How can I do this? I am looking for a dynamic horizontal sumif if that makes sense where I can set the number of columns to sum across based on the month number.
