Create Monthly Spend Chart

's Computer Specifications

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

Thanks

's Computer Specifications

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"hals_left" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>I Have dates in column A and amounts in Column B, Is there anyway to
> produce a monthly spend chart from this.
>
> Thanks
>

's Computer Specifications

On 20 Aug, 13:14, "Don Guillett" <dguille...@austin.rr.com> wrote:
> try copying this down
> =sumproduct((month(a2:a22)=row(a1))*b2:b22)
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"hals_left" <cc900...@ntu.ac.uk> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >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.

's Computer Specifications

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

On 20 Aug, 13:14, "Don Guillett" <dguille...@austin.rr.com> wrote:
> try copying this down
> =sumproduct((month(a2:a22)=row(a1))*b2:b22)
>
> --
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@austin.rr.com"hals_left" <cc900...@ntu.ac.uk> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> >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 -

's Computer Specifications

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
(E-Mail Removed)
"hals_left" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On 20 Aug, 13:14, "Don Guillett" <dguille...@austin.rr.com> wrote:
>> try copying this down
>> =sumproduct((month(a2:a22)=row(a1))*b2:b22)
>>
>> --
>> Don Guillett
>> Microsoft MVP Excel
>> SalesAid Software
>> dguille...@austin.rr.com"hals_left" <cc900...@ntu.ac.uk> wrote in message
>>
>> news:(E-Mail Removed)...
>>
>>
>>
>> >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.
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
I want to create a savings cash flow according to what I spend/sav	Talitha	Microsoft Excel Misc	1	7th Jul 2009 06:33 AM
How to create a chart that compares monthly data with an average	Meenie	Microsoft Excel Charting	4	10th Apr 2009 02:31 PM
how to create a monthly chart with number of days	Jetforce 777	Microsoft Access	1	30th Jun 2008 01:16 PM
How do I estimate the year spend if spend is $26000 as of May?	=?Utf-8?B?RmVsaWNpYSBQaWNrZXR0?=	Microsoft Excel Worksheet Functions	4	20th Jun 2006 04:08 AM
Monthly Contact Chart	Bob G	Microsoft Excel Misc	1	7th Mar 2006 02:24 AM