April 18, 2020
I'm now struggling to get dynamically sum up columns, based on an input selection from Excel.
From the table below, you can see [Jan] -> [Dec] displayed from Column B to M.
|Column A||Column B||Column C||Column D||Column I||Column J||Column K||Column L||Column M|
Base on my month selection in Cell below (let's assume this is Cell N1), i want Query to auto sum figures from [Jan] column B up to [ending month] input in excel cell N1.
How could i make it dynamic in P.Query Editor? Thanks alot 🙂
July 16, 2010
If you're still stuck, please provide a sample Excel file with your data and desired result so we can help you further.