try copying this down
=sumproduct((month(a2:a22)=row(a1))*b2:b22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"hals_left" wrote in message
ups.com...
I Have dates in column A and amounts in Column B, Is there anyway to
produce a monthly spend chart from this.

Thanks