Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula that will not return "0" from a blank line
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"(Blank)" return when importing from Access | Excel Discussion (Misc queries) | |||
Iserror - can it return a "blank" value? | Excel Discussion (Misc queries) | |||
How do I return "leave cell blank" using IF logic. | Excel Worksheet Functions | |||
Disabling "wrap text" neuters alt-return line feeds within cell | Excel Discussion (Misc queries) | |||
Return blank for true "if" statement when charting, not 0 | Charts and Charting in Excel |