Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.newusers,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|
Count
Another one:
=ROWS(A2:A10)-COUNTBLANK(A2:A10)
Biff
"suro" wrote in message
ups.com...
Try =countif(a1:a100,"*")
Regards,
Angine Hazzid
|