a simple sum formula does not appear to be recognizing all of the numbers in
the range as numbers, and, therefore is not adding them to the total. I have
tried formatting the column to 'number' but that doesn't help.