| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF - Not an Error
Is there a way to use Countif to count the number of cells in the range that
are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc. =COUNTIF(A1:A5000, ??????) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF - Not an Error
I think just count(a1:a5000) will work as it ignores errors?
"dhstein" wrote: Is there a way to use Countif to count the number of cells in the range that are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc. =COUNTIF(A1:A5000, ??????) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF - Not an Error
Thanks for your response but the entries I have are text and COUNT only
counts numbers "Flower" wrote: I think just count(a1:a5000) will work as it ignores errors? "dhstein" wrote: Is there a way to use Countif to count the number of cells in the range that are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc. =COUNTIF(A1:A5000, ??????) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF - Not an Error
If there are no numbers then you can use
=COUNTIF(A2:A200,"=99^99") it will ignore errors -- Regards, Peo Sjoblom "dhstein" wrote in message ... Thanks for your response but the entries I have are text and COUNT only counts numbers "Flower" wrote: I think just count(a1:a5000) will work as it ignores errors? "dhstein" wrote: Is there a way to use Countif to count the number of cells in the range that are not errors - in other words - they are NOT #VALUE and NOT #DIV 0 etc. =COUNTIF(A1:A5000, ??????) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using "Countif" in macro gives compile error | Excel Discussion (Misc queries) | |||
| Countif error using multiple workbooks | Excel Discussion (Misc queries) | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| countif / sumif function error | Excel Worksheet Functions | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Hybrid Mode
