Home |
Search |
Today's Posts |
#1
|
|||
|
|||
help
hello!
Please help. I put formula and those null records are like this #N/A. I want to count all null records without replacing. Thanks |
#2
|
|||
|
|||
You can include in your formula the ISNA Function
=ISNA(A6) Checks whether #N/A is the #N/A error (TRUE) If you put in a formula next to it: =if(isna(a6),"ERROR","NOT ERROR") then you could count the error's with a CountIf Formula =countif(error_Range,"ERROR") I know there are better ways, just an idea. -----Original Message----- hello! Please help. I put formula and those null records are like this #N/A. I want to count all null records without replacing. Thanks . |
#3
|
|||
|
|||
Try
=COUNTIF(A1:A100,"#N/A") "chi" wrote: hello! Please help. I put formula and those null records are like this #N/A. I want to count all null records without replacing. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|