Counting Nontext Cells : ISNONTEXT « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ISNONTEXT
Input the formula: =SUM(IF(ISNONTEXT(Data),1)), and press Shift+Control+Enter
Input the formula: {=SUM(IF(ISNONTEXT(Data),1))}
17.10.ISNONTEXT
17.10.1.Counting Nontext CellsCounting Nontext Cells