Help with Formula Function

"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" <sighserena@hoymail.com> wrote in message
> news:7B9DEE4F-3E68-4ECA-AE66-3D9FAC3C7B62@microsoft.com...
> > 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 <7921B6ED-87DF-4626-BBDD-DAD3E1EA4A79@microsoft.com>,
"sighsky" <sighserena@hoymail.com> 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.

Use COUNTA() instead.

In article <7921B6ED-87DF-4626-BBDD-DAD3E1EA4A79@microsoft.com>,
"sighsky" <sighserena@hoymail.com> 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.