Forum Discussion
pavankumarmechineni
Aug 16, 2023Copper Contributor
Excel
Hi everyone... I have three columns with data init . The headers are Month and Total sales, total profits. The data is filled till 100th row. Now I need to prepare a table with tot...
- Aug 16, 2023
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.
SergeiBaklan
Aug 16, 2023MVP
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
Aug 16, 2023Copper Contributor
Hi Sergei...I have uploaded the pic with highlighting the totals of pivot table and SUMIFS total sum . Please refer to the formula in the ribbon and let me know my mistake. Thanks.
- Riny_van_EekelenAug 16, 2023Platinum Contributor
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.
- pavankumarmechineniAug 16, 2023Copper ContributorHi....it worked as you instructed . Thanks for the inputs.