Tablepress Reference Value In Another Cell, Same Table
-
I have columns of numbers and I totaled them with =number_format(SUM(C2:C51)). The works. However, I need to show thousands separators in most numbers. If I use something like this in the cell it works: =number_format(577737).
Now the problem. If I put =number_format(577737) in a cell that is summed as above then it crashes =number_format(SUM(C2:C51)). So I’m trying a hidden cell for the formula and I want to put the value from =number_format(577737) in a cell that is summed, hoping to not crash the sum formula.
I tried using =D51 but that gives an error in both the summed cell and the sum formula cell: !ERROR! D51 does not contain a number or expression.
Now what?
It would be wonderful if we could format the whole columns with the thousands separator instead of hacking each cell!
The page I need help with: [log in to see the link]
- The topic ‘Tablepress Reference Value In Another Cell, Same Table’ is closed to new replies.