[Libreoffice-bugs] [Bug 123533] CALC FORMATTING, AVERAGE FUNCTION

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123533

--- Comment #3 from Laurie <laf2005laurie at yahoo.com> ---
Comment on attachment 149379
  --> https://bugs.documentfoundation.org/attachment.cgi?id=149379
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190219/c9bcb999/attachment.html>