Forum Discussion
Excel
pavankumarmechineni Begin by changing the month names to Jan, Feb, Mar in the table in column G. Just like you have them in the data.
Then change the formula in H5 to reference G5 rather than A31. Even better if you enter the reference by clicking on cell G5. That will enter a structured reference @[Month] and all should work just fine.
When referring to A31 like you did, the next rows will refer to A32, A33 etc. and these cells do NOT contain Feb, Mar etc. Your 'February balance' adds up numbers for Mar and March does it for Nov etc.
That's hard to say what's wrong without seeing the file, perhaps you may share it removing sensitive information.
Another option is PivotTable.
pavankumarmechineni Begin by changing the month names to Jan, Feb, Mar in the table in column G. Just like you have them in the data.
Then change the formula in H5 to reference G5 rather than A31. Even better if you enter the reference by clicking on cell G5. That will enter a structured reference @[Month] and all should work just fine.
When referring to A31 like you did, the next rows will refer to A32, A33 etc. and these cells do NOT contain Feb, Mar etc. Your 'February balance' adds up numbers for Mar and March does it for Nov etc.
- Hi....it worked as you instructed . Thanks for the inputs.
