| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Categorize Income and Expenses?
I have a checking account register, columns A, B, C, where DEP = deposit,
numbers are check numbers, and positive and negative amounts as shown below. A B C CHK# Category Amount Dep Festival $30.05 1023 Paint -$14.00 1024 Chalk -$33.00 1025 Paint -$12.00 Dep Member $100.00 Dep Festival $44.00 I would like a report in another worksheet or just a reformat of the data into 2 main categories of Income and Expenses and within each to sum (add) each category . For example, Income Festival $77.05 Member $100.00 Expenses Paint $26.00 Chalk $33.00 How can I do that? Thank you, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I track a rental properties expenses and income | Charts and Charting in Excel | |||
| how do i setup a table of daily income and expenses | Excel Worksheet Functions | |||
| how do i download templates for income, expenses, and misc. | Charts and Charting in Excel | |||
| template for monthly income/expenses corresponding to IRS Schedule | Excel Discussion (Misc queries) | |||
| church expenses, income work sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
