<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - CALC FORMATTING, AVERAGE FUNCTION" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123533#c3">Comment # 3</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - CALC FORMATTING, AVERAGE FUNCTION" href="https://bugs.documentfoundation.org/show_bug.cgi?id=123533">bug 123533</a> from <a class="email" href="mailto:laf2005laurie@yahoo.com" title="Laurie <laf2005laurie@yahoo.com>"> Laurie</a> <pre>Comment on <a href="http://bugs.documentfoundation.org/attachment.cgi?id=149379" name="attach_149379" title="printscreen">attachment 149379</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=149379&action=edit" title="printscreen">[details]</a> printscreen You did not understand but, no I did not enter the WRONG formula!!!Mine was identical to yours, BUT located in the next column over, and copied down the entire column. When some were overtly different than the tally shown in column N, in column P I used sum of them / 12, and that worked. My formula was =AVERAGE (B4:M4) or whatever the row number was and in the P column =SUM(B4:M4)/12. The numbers that calculated were different and the one that was correct was the sum.../12 one. I discarded the file. And, can't reproduce it in a newly opened copy. One thing I worked on for a bit before this occurred was putting my calculations in a new worksheet and when that didn't go so well, I tried to copy some of the data into the new worksheet and I believe that was there abandoned when I finally tried working directly on the original worksheet. Please don't discount this for the reason YOU think I put in the wrong calculation because I am certain I did not. You can discount it for any other reason- I don't care. But it did happen and if someone isn't paying attention, the AVERAGE calculation could malfunction again for something more important than what I was using it for and might not go unnoticed.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>