Not that fried. :-) The sum is 23. The sum function is correct, and the
cells are formatted as numbers. If I copy the values using paste special to
an unused cell, I can sum those totals, but then the total does not
recalculate if the values are changed in the original cells.

"Dave O" wrote:

Just how fried is your brain? Is it possible that the sum of those
values is zero? Or, it may be your formula: i sometimes intend to
enter =SUM(B1:B5) and enter just the (B1:B5) part, which does not
necessarily yield an error.