Help with Formula Function
 

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.

=COUNT(A1:A5)

Mangesh



"sighsky" wrote in message
...
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.

"Mangesh Yadav" wrote:

=COUNT(A1:A5)

Mangesh

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


"sighsky" wrote in message
...
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.

Use COUNTA() instead.

In article ,
"sighsky" wrote:

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.