Quote:
Originally Posted by Spencer101
Hi Cory,
Any chance you could post an example workbook showing the AVERAGE not working as you'd expect?
I've tried putting together something similar and it works for me so I'd like to see where/how yours is going wrong.
|
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.