Pls TOP post here
make sure your range is long enough and make range absolute and your dates
ARE dates.

=sumproduct((month($a$2:$a$2222)=row(a1))*$b$2:$b$ 2222)


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"hals_left" wrote in message
ups.com...
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 -

It just put a single value of 0 in the cell.