Using the "count" function..

[Mary A Perez]

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?

 

[Nick Hodge]

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
[email protected]

 

[Ron Coderre]

If you are trying to calcullate the count of Account Numbers and those
account numbers are text, not numeric, cells...use the COUNTA function.

(the COUNT function only counts numeric cells)

Does that help?
***********
Regards,
Ron

XL2002, WinXP