Dude here..
I'm running MS 13 and trying to insert a formula that will calculate the monthly average for my data for an entire column (approx. 600 entries), tried a variety of formula's & keep getting error messages. I found one at exceljet.net "average-by-month" (sorry I can't post link yet) that is almost identical to what the Dude is trying to accomplish on a smaller scale, and created an exact replica of it, but get 0's in cells G5, 6, & 7? The formula I've been using is =AVERAGEIFS(D5:D12,C5:C12,">="&F5,C5:C12,"<="&EOMONTH(F5,0))
Did I miss a step? Is there something in Column E that the I neglected to include?
Any help is very much appreciated.
Bookmarks