Forum Discussion
Solved
Assistance in using column data from a table to SUM numbers with matching categories
I created this basic sheet to do my book keeping this year. At the end of the year, I think it would be helpful if I had the expenses categorized so at the end of the year I could easily see...
Depending on how exactly you have organised your data table in the second sheet, I suspect that a Pivot Table can achieve all you need. Since you indicated that your knowledge of Excel is not that good, I attach a very basic example you what a pivot table can do, using some of the data you provided in the screenshot. I hope it enables you to get started and suggest you use the help sections in Excel and/or on-line sources and tutorials to learn more about pivot tables. Just google for "pivot table excel" and you'll find quite a few hits. Good luck!
Exactly what I was looking for, thank you so much!
TigerStripes69 You're welcome!