When I take Auto Sum option it returns #REF instead of totals. Worksheet
integrity seems to be fine.
#REF is an error in a direct cell reference. It often appears after
deleting some rows or columns. Check the formula for a #REF right in
the formula, or a mis-typed reference. Or check all the cells that are
being added in the SUM to see if any of them have a bad reference.
