Hidden Cells?????

[T.B.]

I keep getten the wrong sum in a certian colume of numbers that i have alot
of blanks in. I'm almost sure that i must have a hidden cell somewhere.How do
I find it or better yet how do I get rid of it or any others that may be
hidden in that colume?

 

[Ken Wright]

You can't hide a cell. You can hide a row or a column but not a cell.
Click on the little grey square at the top left of the sheet such that it
selects the entire sheet. Then do format / Row / Unhide and Format / Column
/ Unhide and you will have unhidden any hidden rows/columns.

Now, that having been said, unless you are using the SUBTOTAL function, that
is not actually your problem anyway, as hiding will not take the data out of
the equation.

Give us some details of what the problem is. How far out is the data.