https://bugs.documentfoundation.org/show_bug.cgi?id=123533
--- Comment #3 from Laurie <laf2005lau...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
