View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge
 
Posts: n/a
Default Using the "count" function..

Mary

Try COUNTA which counts 'non empty' cells in the range, rather than cells
with just numbers, as your account 'numbers' may not be, or be seen as such
by Excel

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Mary A Perez" wrote in message
...
I wanted to use the "count" function to total a column of account numbers.
I
used =Count(A9:A188) but the result is "0". Am I not using the correct
function?