Just to clarify.........

=IF(Sheet2!A1="","",Sheet2!A1) entered in a cell on Sheet1 states "If

Sheet2!A1 has no value then show nothing in the cell with the formula but if

Sheet2!A1 has a value, show that value here"


Gord

On Sat, 05 May 2007 19:34:08 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Replace it with a formula similar to one I posted below which returns a null
string which Excel will ignore in your =COUNT(range) formula.