princeninan
New Member
- Joined
- Aug 7, 2023
- Messages
- 1
- Office Version
- 2019
- Platform
- Windows
Hello excel experts,
I have a list of items in one table and give category for each item. Then in another table i have summary of items category wise with total quantity using sumif formula. If i add new category can it be automatically added to summary table.
For eg in below table, I added a new category High, i would like to show in sumif table automatically. Now I writing High in sumif table and copying formula from above row. Pivot table can be an alternnative but needs to manually refresh after new category is added.
I have a list of items in one table and give category for each item. Then in another table i have summary of items category wise with total quantity using sumif formula. If i add new category can it be automatically added to summary table.
For eg in below table, I added a new category High, i would like to show in sumif table automatically. Now I writing High in sumif table and copying formula from above row. Pivot table can be an alternnative but needs to manually refresh after new category is added.