A basic sum function does not work. The zero number reported below is the result of the SUM function SUM -(C2:C40) If I run this spreadsheet on Google Sheets, the formula correctly reports $1716.10 Please address this basic issue. I have lost faith in the accuracy of LibreOffice tools. Date Description Amount AccountType 2021-03-11 796229 POS CHCKING SIG 03/10 09:43 WALGREENS #6111 LAFAYETTE CO 06284676 796229 $-339.99 HSA 2021-03-03 225730 POS CHCKING PIN 03/03 15:31 WALGREENS 1830 30TH BOULDER CO 02482T32 22573 $-15.23 HSA 2021-03-03 202207 POS CHCKING PIN 03/03 15:18 KING SOOP 1650 30TH BOULDER CO 11006165 20220 $-21.22 HSA 2021-03-03 703007 POS CHCKING PIN 03/03 10:20 WALGREENS 1600 COAL SUPERIOR CO 06467T41 7030 $-4.39 HSA 2021-02-16 443543 POS CHCKING SIG 02/13 05:11 BRIOVARX 800-562-6223 IL 20040269 443543 $-5.00 HSA 2021-02-11 45227 POS CHCKING SIG 02/11 05:19 OPTUMRX 800-562-6223 CA 84821867 045227 $-136.51 HSA 2021-01-27 314425 POS CHCKING SIG 01/26 04:55 COLO MEDICAL PSYCHI BOULDER CO 10100130 31442 $-299.85 HSA 2021-01-26 127354 POS CHCKING PIN 01/26 14:42 KING SOOP 1650 30TH BOULDER CO 11006167 12735 $-11.16 HSA 2020-12-22 845846 POS CHCKING SIG 12/22 04:53 BRIOVARX 800-562-6223 IL 94833831 845846 $-5.00 HSA 2020-12-22 139291 POS CHCKING PIN 12/21 18:02 WALGREENS 1600 COAL SUPERIOR CO 06467T41 1392 $-11.32 HSA 2020-11-20 396753 POS CHCKING SIG 11/20 04:39 BRIOVARX 800-562-6223 IL 18416229 396753 $-5.00 HSA 2020-11-18 44971 POS CHCKING PIN 11/17 17:01 WALGREENS 1600 COAL SUPERIOR CO 06467T41 04497 $-11.32 HSA 2020-11-05 677055 POS CHCKING SIG 11/04 04:46 BOULDER EYE SURGEON 303-4443000 CO 06849800 6 $-23.04 HSA 2020-10-29 942276 POS CHCKING SIG 10/29 04:48 BRIOVARX 800-562-6223 IL 78966422 942276 $-5.00 HSA 2020-10-15 881186 POS CHCKING SIG 10/14 05:12 COLO MEDICAL PSYCHI BOULDER CO 13400052 88118 $-17.18 HSA 2020-10-01 135482 POS CHCKING PIN 10/01 15:24 KING SOOP 1650 30TH BOULDER CO 11006167 13548 $-13.75 HSA 2020-09-29 696255 POS CHCKING SIG 09/28 01:54 PHR*COLORADORETINA 303-2611600 CO 67382042 69 $-23.25 HSA 2020-09-23 760696 POS CHCKING SIG 09/23 05:25 OPTUMRX 800-562-6223 CA 80365775 760696 $-87.66 HSA 2020-09-23 683284 POS CHCKING SIG 09/23 05:37 OPTUMRX 800-562-6223 CA 80347492 683284 $-28.78 HSA 2020-09-15 74752 POS CHCKING SIG 09/14 01:30 PHR*COLORADORETINA 303-2611600 CO 19295201 074 $-23.25 HSA 2020-09-15 588986 POS CHCKING SIG 09/14 05:07 COLO MEDICAL PSYCHI BOULDER CO 11200070 58898 $-34.37 HSA 2020-09-14 146706 POS CHCKING SIG 09/12 04:59 BRIOVARX 800-562-6223 IL 95931843 146706 $-5.00 HSA 2020-08-20 787932 POS CHCKING SIG 08/19 04:55 COLO MEDICAL PSYCHI BOULDER CO 19600058 78793 $-17.19 HSA 2020-08-20 259651 POS CHCKING PIN 08/19 16:36 KING SOOP 1650 30TH BOULDER CO 11006167 25965 $-11.58 HSA 2020-08-05 117176 POS CHCKING PIN 08/05 15:47 KING SOOP 1650 30TH BOULDER CO 11006166 11717 $-1.30 HSA 2020-07-23 10539 POS CHCKING PIN 07/22 18:11 KING SOOP 1650 30TH BOULDER CO 11006166 010539 $-11.56 HSA 2020-07-23 648252 POS CHCKING SIG 07/22 05:04 COLO MEDICAL PSYCHI BOULDER CO 17800050 64825 $-34.36 HSA 2020-07-15 896136 POS CHCKING SIG 07/14 09:56 ASSOCIATES IN FAMIL FORT COLLINS CO 98696979 $-162.54 HSA 2020-07-06 89576 POS CHCKING SIG 07/05 04:03 PHR*COLORADORETINA 303-2611600 CO 73878933 089 $-23.25 HSA 2020-06-23 656255 POS CHCKING SIG 06/23 04:55 OPTUMRX 800-562-6223 CA 99640363 656255 $-87.55 HSA 2020-06-22 375126 POS CHCKING SIG 06/20 04:42 OPTUMRX 800-562-6223 CA 12670827 375126 $-11.44 HSA 2020-06-17 41341 POS CHCKING PIN 06/16 18:13 WALGREENS 1600 COAL SUPERIOR CO 06467T41 04134 $-12.29 HSA 2020-05-07 59695 POS CHCKING PIN 05/06 18:03 WALGREENS 1600 COAL SUPERIOR CO 06467T42 05969 $-5.54 HSA 2020-05-04 256624 POS CHCKING SIG 05/02 01:51 PHR*COLORADORETINA 303-2611600 CO 91499877 25 $-23.25 HSA 2020-04-09 EARNINGS ON EXCESS CONTRIBUTION 2019 $-2.32 HSA 2020-04-09 335894 POS CHCKING PIN 04/08 17:45 WALGREENS 1600 COAL SUPERIOR CO 06467T41 3358 $-3.21 HSA 2020-04-09 EXCESS CONTRIBUTION DISTRIBUTION 2019 $-1487.55 HSA 2020-03-25 232962 POS CHCKING SIG 03/25 04:45 BRIOVARX 800-562-6223 IL 39222775 232962 $-5.00 HSA 2020-03-23 111585 POS CHCKING PIN 03/23 15:31 KING SOOP 1650 30TH BOULDER CO 11006167 11158 $-3.68 HSA 0
*** This bug has been marked as a duplicate of bug 141152 ***