How to get sums making home budget workbook?

Microsoft Excel 2003 (full product)
February 8, 2011 at 09:01:44
Specs: Windows 7
I need help making my own at home budget spreadsheet! I've got everything plugged in but need help getting the dollar values for each category. In have a column with each transaction i've made for the month with a column right next to it with the corresponding dollar amount and then i've created a column next to that with category codes i've made up, ie gas is G, entertainment is E, etc.

How can I have the dollar amounts for everything coded G sum to a cell at the top of the spreadsheet, and etc for each category code I made. Please help! :)

See More: How to get sums making home budget workbook?

Report •

February 8, 2011 at 10:12:09
Read up on the SUMIF function in the Excel help files.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question