I have a Column with numbers from R3 to R33.
Some rows are empty from R20 to R33 since they are filled in day by day
I’m trying to add cells R5 R12 R19 R26 R33
To get the total In another cell B38
Since cells R26 and R29 are empty at this time, I keep getting the #VALUE! error.
Tried using an IFERROR to fix it but it don’t work.
Any simple solutions?
Please attach a sample file.
Hi Dannyg, post an example file, it makes it easier to see the data.
Hallo
=SUM(R5;R12;R19;R26;R33)
An empty cell is treated as a 0 by the addition process. Verify that the cells are really empty (not containing a space).
“It” as in “my (unspecified) formula”? Because IFERROR definitely works, as designed; but empty cells do not contain error, so IFERROR on the empty cell is not going to help. The error arise during summation in the formula cell (which formula you also forgot to provide, not to mention a sample document), not in source cells.
Sorry guys I didn’t get back to everyone.
I was able to get it to work.
A post was made a while back and I tried it and it didn’t work, then for some reason I tried it again and it worked.
There was a setting in the “Options” LibreOffice Calc" “Formula” “Detailed Calculation Options”
And I changed the setting to
Conversion from text to number “Treat as Zero”
And “Treat empty string as Zero”
So now just putting in
for example
Cell B39 =R6+R13+R20+R27 works perfect with no value error.