https://bugs.documentfoundation.org/show_bug.cgi?id=148831
Bug ID: 148831
Summary: Can't believe I'm typing this, but =SUM(A3:A37) is
providing incorrect results
Product: LibreOffice
Version: 7.2.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: robjac...@gmail.com
Description:
I have a .x.xlsx file that I use to keep track of my pay by adding up the
number of visits I perform at a physical therapy clinic . . .
In Column A I have a "1" in each cell indicating various visits a given patient
on a given day. Then I have a "Total" at the end where I sum up the number of
"1"s in the column, using =SUM(A3:A37). There are 24 "1"s in the column, yet
the SUM says it is 15.
The column cell format is set so that they are "Numbers."
I have been using Excel and Libre Office Calc for years with no issues and
happily. I must be doing something wrong, but I can't find out what it is.
Steps to Reproduce:
1.I have a series of "1"s typed in column A in a Calc sheet.
2.I am trying to sum those up by using =SUM(A3:A37), the cells A3:A37 that have
"1s" in them. The answer consistently is "15" even though I have a total of 24
"1"s. Even if I change the selected cells to A3:A27, where I have actual
numbers and no empty cells, the answer is 15, not 24 as it should be.
3.
Actual Results:
See above.
Expected Results:
The answer should be 24, not 15.
I have no negative numbers. I have tried deleting all the "1"s and retyping
them. Nothing changes. When you click on the cell with the formula, it
highlights the cells it is adding up, and it includes cells with 24 "1"s.
Reproducible: Always
User Profile Reset: No
Additional Info:
I will try adding an attachment.
--
You are receiving this mail because:
You are the assignee for the bug.
