Averaging daily data to monthly

[karthikeshswami]

Hello People,

I am looking for some help on the attached dataset. I am trying to average out the figures in the "Data" sheet to give me a monthly average in the "Monthly average" sheet.

I tried out the Averageif function and the sumif / counif functions, albeit unsuccessfully. The problem seems to be with the dataset which has gaps in between...unfortunately there isnt much that I can do about it.

Any help would be of use and ofcourse very much appreciated.

Thanks

KS

[ChemistB]

Edit: Nevermind, just saw the second sheet. Oops

[ChemistB]

Try this formula in Monthly Averages B2

=IFERROR(SUMPRODUCT(Data!B2:B1000, --(MONTH(Data!$A2:$A1000) = MONTH($A2)), --(YEAR(Data!$A2:$A1000)=YEAR($A2)))/SUMPRODUCT(--(ISNUMBER(Data!B2:B1000)), --(MONTH(Data!$A2:$A1000) = MONTH($A2)), --(YEAR(Data!$A2:$A1000)=YEAR($A2))),"")
Can be dragged across and down
Does that work for you?

[karthikeshswami]

This works swell for me...much appreciated...thanks

KS