Excel 2007 : Calculating year to Date Average

**PSU1987** · 06-23-2011, 10:41 AM

I have a spreadsheet showing monthly figures for 2010 and 2011. I need to write a formula to calculate the year to date average for 2010 for the same current month in 2011. any Ideas??

working example.xlsx

**Paul** · 06-23-2011, 04:18 PM

Hi PSU1987, welcome to the forum.

This might work for you for the 2010 YTD averages:

=AVERAGE(OFFSET($D5,0,0,1,COUNT($D6:$O6)))

The formula first counts the number of entries in the row below (2011), then uses that number as the width for the OFFSET function. The AVERAGE function then averages the cells from D5:?5.

**tooyummy** · 10-18-2014, 01:01 PM

I am trying to calculate the YTD average of requests but i keep getting 0. So, I am not sure which number I should be using. For example, I am in the month of
September and we have had 1359 requests filled from January to September. Is the correct formula =AVERAGE(O36/9)?

I have attached an example of my spreadsheet here.

**protonLeah** · 10-18-2014, 08:56 PM

tooyummy,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.