It is also the number of cells, not rows. Subtle, but relevant.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"tjtjjtjt" wrote in message
...
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
|