Hi
According to microsoft.com and the online help =COUNTA(A1:A7,"Two") should
give you the number of rows containing "Two", but all you get when you try
the above is a Formula error !
What do I miss ?
Thanks in advance.
Steen
Hi
According to microsoft.com and the online help =COUNTA(A1:A7,"Two") should
give you the number of rows containing "Two", but all you get when you try
the above is a Formula error !
What do I miss ?
Thanks in advance.
Steen
Steen
I tried your COUNTA formula on my excel97 and, despite the rows A1:A7 being empty, a 1 appeared in C1 (the cell where the formula had been put). Very strange!
You should be using COUNTIF instead.
=COUNTIF(A1:A7,"Two")
tj
"rabol" wrote:
> Hi
>
> According to microsoft.com and the online help =COUNTA(A1:A7,"Two") should
> give you the number of rows containing "Two", but all you get when you try
> the above is a Formula error !
>
> What do I miss ?
>
> Thanks in advance.
> Steen
>
It is also the number of cells, not rows. Subtle, but relevant.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"tjtjjtjt" <[email protected]> wrote in message
news:[email protected]...
> You should be using COUNTIF instead.
> =COUNTIF(A1:A7,"Two")
>
> tj
>
> "rabol" wrote:
>
> > Hi
> >
> > According to microsoft.com and the online help =COUNTA(A1:A7,"Two")
should
> > give you the number of rows containing "Two", but all you get when you
try
> > the above is a Formula error !
> >
> > What do I miss ?
> >
> > Thanks in advance.
> > Steen
> >
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks