I have a date column and an expense column, so all my expenses on a
particular day are recorded.

On another sheet, i want to display a list of months and have the sum
of my expenses for each month in the adjacent cell.

Sounds simple enough right. I thought of using the MONTH function
somehow but its useless, ican't get it to work. Even after reading the
manual i can't understand it.

Can anyone tell me the way to do this.

Date Expenditure
26-Apr-2004 20
26-Apr-2004 34
26-Apr-2004 12
26-Apr-2004 32
02-May-2004 11
04-May-2004 53
04-May-200411
04-May-2004 11
05-May-2004 23
05-May-2004 24

The problem I have I think is getting excel to extract the month from
the 'date' column.


---
Message posted from http://www.ExcelForum.com/