We'd like to sum our estimated cable length in a report.
I seem to be able to sum "spreadsheet" values, but not "database" values
When I tried to sum a cell it only sees the whole integer
example summing database rows H2.1 through H2.23 will show as =sum(H2..H2) and report #Value!
of course if I sum spreadsheet rows H2 through h44 =sum(h2..h44) is works with no errors
There is a built-in sum values filter but, I don't see where the sum is p