H
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
produce a monthly spend chart from this.
Thanks
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
try copying this down
=sumproduct((month(a2:a22)=row(a1))*b2:b22)
=sumproduct((month(a2:a22)=row(a1))*b2:b22)
H
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.
H
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 -
D
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)
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)