Return the number of logical values (TRUE or FALSE) in a range named Data : ISLOGICAL « Information functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Information functions
  3. ISLOGICAL
Input the formula: =SUM(IF(ISLOGICAL(A1:B4),1)), and Shift+Control+Enter
17.8.ISLOGICAL
17.8.1.ISLOGICAL returns TRUE if the value is a logical valueISLOGICAL returns TRUE if the value is a logical value
17.8.2.Return the number of logical values (TRUE or FALSE) in a range named Data