Help with Formula Function

S

sighsky

Hi,
Here's my worksheet with Row from A1 to A5 ( A1:A5). I would like to
count the item of those rows. Examples: If there's something in row A1 to A5
then the cell of A6 will = 5. If any of the cell is empty then the cell A6
will be = to the cell with value on it.

Anu help would be very appreciated.
 
S

sighsky

Mangesh Yadav said:
=COUNT(A1:A5)

Mangesh
Click to expand...
Thanks for a quick reply. But the cell A1:A5 is not always the numeric
number. sometime the cell have the character. If I have a character on cell
A1 then the Count function desn't recongniz. How can I count anything on
those cells even there are character valu.

Thanks
 
Top