PDA

View Full Version : [SOLVED] can anyone help me resolve this error



austenr
10-03-2005, 01:51 PM
A coworker is getting this error on a =sum(a1:A30000)

"The formula in this cell refers to a range that has additional numbers adjacent to it". Any one know how to resolve this?

Zack Barresse
10-03-2005, 03:22 PM
Don't know if I've come across this myself. Can you post a sample workbook?

austenr
10-03-2005, 03:57 PM
Figured it out. There were blank cells and they were formatted as text. When I changed them to number it was fine. I don't believe I have run across that one either. Oh well live and learn. Only found it out after a few tries. Should have though of that first. Was not my work so it took me a few.

:hi: