Average value for the given month irrespective of any year

**thilag** · 07-04-2014, 05:26 AM

Hello Friends

Please find the attached 2010 version excel file <Average value for Given month in any year>.

In yellow cells i need to plot the average for the January month (Any year i.e., all year). I written 2 formulas both are not working for next entries working for first entry only. For first entru also it shows error value (error 293.5911 actual is 259.7243).

I plotted the correct average by manually calculated for verification.

Kindly help me to plot the averages in yellow cells by formula.

thanks in advance.

thilag

**haripopuri** · 07-04-2014, 05:32 AM

You have to enter the formula 1 with Control+Shift+Enter in first cell, and drag for all other cells.

**thilag** · 07-04-2014, 05:34 AM

Hello Friends

An update
I made an error in the cells J6:J17 year should be 2007 but it was 2014, if i changed the year to 2007 from 2014 then it is working (As a array formula)

thanks

thilag

**haripopuri** · 07-04-2014, 05:49 AM

Array formula works that way, doesn't matter if it is year 2007 or 2015 in J6:J17. Please update the thread as solved.

**Vikas_Gautam** · 07-04-2014, 05:51 AM

hi thilag
You first formula has worked...
but you have to refresh all formulas after draging the function..

check the attachment...

Say thanks, Click *