Dear Ashish,

What I really want is the formula but not a pivot table.
ANyway thank very much for your assistance.

Kent



"Ashish Mathur"
...
Hi,

You could work with a pivot table. Drag date to the row area and expense
to the data area. Now click on any one cell in the date column and on the
pivot table toolbar, click on Group and Show Detail Group. Select
Months (that may be the default selection).

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Kent" wrote in message
...
Dear all,

I have a worksheet

Date Expense
2/1/09 5000
10/1/09 3000
15/1/09 1500
23/2/09 2500
24/2/09 2400
1/3/09 1500
2/3/09 1000

I now want to subtotal the expenses into a new table month by month

Month Expense
Jan 09
Feb 09
Mar 09

WHat should be the formula in the "Expense" column?

Thank you

Kent