spreadsheet macro

[tmorone]

I prepare my taxes for the accountant in an excel
spreadsheet. I have thirty rows with category names (trave-
-lodging, travel-foor, entertainment, telephoen etc.).

In the first column I have date, second column
description, third column amount. The sum of all the rows
ties back to the third column.
I need a macro that automatically soreads the thired
column to the appropriate category in the row headings.

 

[Peter Atherton]

-----Original Message-----
I prepare my taxes for the accountant in an excel
spreadsheet. I have thirty rows with category names (trave-
-lodging, travel-foor, entertainment, telephoen etc.).

In the first column I have date, second column
description, third column amount. The sum of all the rows
ties back to the third column.
I need a macro that automatically soreads the thired
column to the appropriate category in the row headings.
.

A formula should do it

=SUMPRODUCT(--(B2:B31="Entertainment")*(C2:C31))

(e-mail address removed)
Peter