With your supplied data in A1:B7 try:

="Oct 2007 = "&SUMPRODUCT((A1:A7<"")*(MONTH(A1:A7)=10)*(YEAR(A 1:A7)=2007))

or:

=TEXT(A1,"mmm yyyy")&" =
"&SUMPRODUCT((A1:A7<"")*(MONTH(A1:A7)=10)*(YEAR(A 1:A7)=2007))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"coastergeez" wrote in message
...
I cant seem to figure this out. I have a worksheet that has a column
of dates. I want to create a chart that shows the sum of all the items
broken out by month and year. How can I do this?

Example:

10/10/2007 16:04
10/17/2007 16:10
1/3/2008 10:32
1/5/2008 14:00
2/4/2008 11:00
2/4/2008 11:30
2/10/2008 15:00

I would like this output to create a chart from -
Oct 2007 = 2
Jan 2008 = 2
Feb 2008 = 3

TIA