horizontal

Question

Is there a way to dynamically summarize a row of data ($$) under a row of dates to include each new month. In other words can I create a YTD number at the end of the row, without having to re-create my data to ad each new month to the previous. Exampe 2007: Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTDTotal 100 200 300 400 500 100 100 200 300 200 400 300 I want to create a YTD column at the end of the second row showing: 1500 YTD Total. Then for June include June dynamically (1600) etc.... Thanks! Phil

Anonymous · Answer

Not sure if I get your problem. Do you mean the SUM() formula with the row does not work?
That is the simplest solution if you are entering the monthly numbers per month.

If you have all these values and need to sum them up based on the current month, you need to use the MONTH() with the NOW() formulas to get a month offset and use a relative reference for the SUM() formula.

Related Topics:

Trustworthy Expert Solutions

1 Answer

Anonymous

Add Your Answer

Attachments: Added items

Ask a Question

Check Out the Mobile Browsers Report

Top Microsoft Computers & Internet Experts

Sudeep Chatterjee

Grand Canyon Tech

Brad Brown

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Manuals & User Guides

Related Topics:

Trustworthy Expert Solutions

1 Answer

Anonymous

Add Your Answer

Attachments: Added items

Related Topics

Ask a Question

Popular Questions

CSV file to Import correctly into Excel 2003

Indian Rupee format in Excel spreadsheet

How to select all sales entry in tally 9 and how to delete it

Excel file opens in read only mode

Using excel to solve problem by trial and error method