| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Create Monthly Spend Chart
I Have dates in column A and amounts in Column B, Is there anyway to
produce a monthly spend chart from this. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Monthly Spend Chart
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 a monthly spend chart from this. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Monthly Spend Chart
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Monthly Spend Chart
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Create Monthly Spend Chart
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I estimate the year spend if spend is $26000 as of May? | Excel Worksheet Functions | |||
| Program to calculate how much I can afford to spend? | Excel Discussion (Misc queries) | |||
| How do I create a spreadsheet to track monthly inventory | New Users to Excel | |||
| How do I create a report to monitor monthly utilities | Excel Worksheet Functions | |||
| How do I create a formula that will calculate monthly changes fro. | Excel Worksheet Functions | |||
Hybrid Mode
