Home |
Search |
Today's Posts |
#1
|
|||
|
|||
counta
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to Copy COUNTA() with cell references | Excel Worksheet Functions | |||
Problems copying cells using offset and counta | Excel Discussion (Misc queries) | |||
Count or CountA | Excel Worksheet Functions | |||
counta | Excel Worksheet Functions | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |