Quote:
Originally Posted by Cory Boyd
Thanks for responding! Here is the sample data I entered using the custom format 0"'".00"''" (in cells D2:D7):
22'.07''
23'.01''
21'.11''
22'.05''
23'.05''
24'.08''
in cell D12, I have the formula =AVERAGE(D2:D10) and it returns the result 22'.56", which I can't wrap my head around. I have tried adjusting the formula cell range to D2:D7 and it still returns the same result.
Thanks.
|
I may be missing something fundamental here, but that looks like the right answer to me. What are you expecting it to be?
Just to test it, put this formula in cell E2 and copy down. =AVERAGE(D$2:D2)
It will allow you to see the running average and by the time you get to cell
E7 you will have your 22'.56" average.