Sorry, my mistake. That woks fine, Thank-you


On 20 Aug, 13:14, "Don Guillett" wrote:
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 amonthlyspendchartfrom this.

Thanks- Hide quoted text -

- Show quoted text -