Create Monthly Spend Chart

[hals_left]

I Have dates in column A and amounts in Column B, Is there anyway to
produce a monthly spend chart from this.

Thanks

 

[Don Guillett]

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

 

[hals_left]

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -

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

 

[hals_left]

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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software






- Show quoted text -

 

[Don Guillett]

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)