View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default What formula should I use to count a number of records?

COUNT will count only numeric cells.

COUNTA will count non-blank cells.


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:32:06 -0700, Francis
wrote:

assuming you have the list of computers in A2 to A100
try
=COUNT(A2:A100) or
or if there are blank cells in between
=COUNTA(A2:A100)