Auto Sum returns #REF instead of total

T

Troubled

When I take Auto Sum option it returns #REF instead of totals. Worksheet
integrity seems to be fine.
 
S

Spiky

When I take Auto Sum option it returns #REF instead of totals. Worksheet
integrity seems to be fine.
Click to expand...

#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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing Access DB into Excel changes my calculated fields in Exc 3
Auto Sum not working correctly 1
#REF error! 8
Copy formula from one worksheet to another to get value in 2nd wks 2
#ref 1
Auto Sum 0
sumif issues 1
Find Sum with Citeria 2

Top