Mega Code Archive

 

Categories / MSOfficeExcel 2007 Tutorial / Information Functions

 

Return the number of logical values (TRUE or FALSE) in a range named Data

Input the formula: =SUM(IF(ISLOGICAL(A1:B4),1)), and Shift+Control+Enter