I have a data table ( originally pulled from another spreadsheet using SQL
query - probably irrelevant to the issue ).
When I try to SubTotal with the sum function it incorrectly returns zero for
all results. The cell formats are number. Any idea what's going on here ?