Microsoft KB Archive/24279

Excel: Counting Nonblank Cells in Versions 1.06 and Earlier PSS ID Number: Q24279 Article last modified on 11-14-1990 PSS database name: M_eXceL

1.00 1.03 1.04 1.06

MACINTOSH

Summary:

To count the number of nonblank cells in a selection (when using Microsoft Excel version 1.06 or earlier), use the following formula

=SUM(IF(LEN(“ref”)>0,1,0))

where “ref” is the reference to the cells to be checked.

The formula should be entered as an array formula by pressing COMMAND+ENTER after the formula has been typed.

Copyright Microsoft Corporation 1990.