Thread: Getting the Average of multiple columns

Hello all!

I am trying to get the 5 year average for each month (ie:jan 2007, jan 2008, jan 2009....) I was trying to get a averageif function to work but perhaps i am not familiar with it enough. Any help would be greatly appreciated. Attached is a dummy ws.

Try this

put the numbers 1 to 12 from A5 to A16 (these are your months)

then in B5

=SUMPRODUCT((MONTH(B$1:AW$1)=A5)*(B$3:AW$3))/SUMPRODUCT(--(MONTH(B$1:AW$1)=A5))

and copy down to B16

Looks like it's working...! :-)