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,