| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTA failing?
COUNTA simply counts the number of nonblanks in the range(s) you specify and
any values you input as arguments. In your case there is nothing in D2:D4 and you specified one other argument. Therefore the result of 1 is correct. You could put anything in cell d3 and the result would always change to 2. You can even insert a value that results in an error (like =NA() or =1/0). As Dave mentioned, I think you are using the wrong function. If you want it to count the number of cells in D2:D4 that contain "jones" use this formula =COUNTIF(D2:D4,"Jones") |
| 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 | |||
Threaded Mode
