counta

[Guest]

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

 

[Guest]

You should be using COUNTIF instead.
=COUNTIF(A1:A7,"Two")

tj

 

[Bob Phillips]

It is also the number of cells, not rows. Subtle, but relevant.

--

HTH

RP
(remove nothere from the email address if mailing direct)