To use this function, choose .

The number of missing values, nonmissing values, and total observations in a column of a worksheet.

- N missing is the number of cells that contain the missing value symbol *.
- N nonmissing is the number of cells that contain actual data.
- N total is the sum of these two statistics, or the total number of observations in a column.

Function | Syntax |
---|---|

N missing for a column | NMISS(number) |

N nonmissing for a column | N(number) |

N total for a column | COUNT(number) |

N missing for a row | RNMISS(number,number,...) |

N nonmissing for a row | RN(number,number,...) |

N total for a row | RCOUNT(number,number,...) |

For number, specify the column number or numbers; or for row statistics, specify each column number to define the length of the rows.

Column | Calculator expression | Result |
---|---|---|

C1 contains *, 3, *, 7 | NMISS(C1) | 2 |

C1 contains *, 3, 4, *, 5 | N(C1) | 3 |

C1 contains 6, 3, *, 12 | COUNT(C1) | 4 |

C1 contains *, C2 contains 3, contains *, and C4 contains 7 | RNMISS(C1,C2,C3,C4) | 2 |

C1 contains *, C2 contains 4, C3 contains *, and C4 contains 5 | RN(C1,C2,C3,C4) | 3 |

C1 contains 6, C2 contains 3, C3 contains *, and C4 contains 12 | RCOUNT(C1,C2,C3,C4) | 4 |