View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fred Atkinson Fred Atkinson is offline
external usenet poster
 
Posts: 8
Default Counting Marked Cells

Is there a function available that would count the number of
cells that are not blank?

Example: Attendance sheet:

A3 A4 A5 A6 A7
M T W Th F
X X X X =<somefunction(A3:A7)
<somefunction would yield '4' in this case.

Regards,



Fred