Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTA failing?
In a brand new worksheet in cell D1 I type =counta(d2:d4,"jones"). I get the answer 1 (one). If I then type jones into cell d3, I get 2. Why? Is there a bug in counta? Dick Penny -- dpenny ------------------------------------------------------------------------ dpenny's Profile: http://www.excelforum.com/member.php...o&userid=19708 View this thread: http://www.excelforum.com/showthread...hreadid=564365 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Help based around countif and counta | Excel Discussion (Misc queries) | |||
COUNTA for a cell with a formula | Excel Worksheet Functions | |||
Insert New Rows based on COUNTA() | New Users to Excel | |||
COUNTA, COUNTIF? | Excel Worksheet Functions | |||
Unable to Copy COUNTA() with cell references | Excel Worksheet Functions |