It is a link to whatever is in a cell from another sheet. So there is
nothing in the cell except the link.


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Ed

What do the formula cells return if there is not data to compute?

i.e. a null string like "" which COUNT would ignore or something else?


Gord Dibben MS Excel MVP

On Sat, 5 May 2007 04:34:51 -0400, "Ed Davis"
wrote:

How would I use count when a formula is in cells but if the cell has not
data except the formula how would I use count to count only the cells that
have a number and disregard the cells with just the formula.

Thanks in advance.

Ed Davis