=IF(Sheet1!A1="","",Sheet1!A1)


Gord Dibben MS Excel MVP

On Thu, 14 Jan 2010 13:23:02 -0800, indyjojo
wrote:

Using excel 2003

I have a workbook that I will be using to calculate stumpage and payroll. To
get the data moved from the load sheet to the stumpage sheet, I have =(cell
address) and I copied that down. There are 30 lines of data but not all lines
will be used. If there is no data in a line I get "0" on the stumpage sheet.

For this cycle there are only 11 loads. On the stumpage sheet, I entered the
formula =count(loads) (loads is the range name of the 30 lines of data in
colA). I choose count because in that column I have ticket numbers. So I
wanted to know how many cells had numbers in that column so I would know how
many lines would be on the stumpage sheet.

I need a formula that will look in the cell and return only the cells that
have text.
Any help would be appreciated.