Moderators, if this is in the wrong place, or is in any way of not being in compliance, please let me know and I will gladly make any corrections that I need too. I value the forum and wish to do thing correctly.
I have a large column of numbers, sorted by date, that i used to get the average by manually averaging the date range that I needed.
I thought I could use an averageifs with date ranges but when I do, the answers differ (though they are correct on some ranges.)
In the spread sheet attachment I get an answer of 467.95 for a manual average, and 472.37 when I use averageifs. (=AVERAGEIFS(B:B,A:A,">="&$F$5,A:A,"<="&$F$6))
I am a novice and most likely making a simple error, but I cannot locate anything out of place.
Thank you
Bookmarks