| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How can I count #N/A in a column?
How can I count #N/A in a column?
TIA, Rasoul Khoshravan |
|
#2
|
|||
|
|||
|
In article ,
"Rasoul Khoshravan Azar" wrote: How can I count #N/A in a column? TIA, Rasoul Khoshravan Try... =COUNTIF(A1:A10,#N/A) Hope this helps! |
|
#3
|
|||
|
|||
|
Hi,
This array formula (Ctrl-Shift-Enter) =SUM(--ISNA(A1:A100)) Notice you can't choose ALL the column. Use a range instead. Regards, Daniel M. "Rasoul Khoshravan Azar" wrote in message ... How can I count #N/A in a column? TIA, Rasoul Khoshravan |
|
#4
|
|||
|
|||
|
Dear Domenic
Thanks. It was easy but informative. Regards, Rasoul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count the text in a column - Part II | Excel Discussion (Misc queries) | |||
| How do I count the amount of text in a column and then add them | Excel Discussion (Misc queries) | |||
| How do I count or display unique data in a column? | Excel Worksheet Functions | |||
| Can I count values in column 1 if criteria in column 2 are met | Excel Worksheet Functions | |||
| Count rows based on multiple criteria | Excel Worksheet Functions | |||
Linear Mode
