You want a Pivot Table. It will do exactly what you want. See
http://www.cpearson.com/excel/pivots.htm for more information.

Regards,
Fred

"bobby769" wrote in message
...
My sheet has transactions sorted by date.
I need to add transactions for each month.

I was hoping that in a seperate tab I'd be able to have cells w' Jan, Feb,
Mar, etc...
and next to that the equation would look at the transactions tab and bring
in the sum of transactions for Jan, Feb, Mar, etc...