Excel Count Function

  • Thread starter Thread starter jayeliz
  • Start date Start date
J

jayeliz

hello everyone

I need help with a function that will analyze a column of cells, coun
the cells that have data and put that number in a different cell.

I'd appreciate any help. Thanks
 
Jay,

=COUNTA(A2:A10) will give you the count of cells that aren't empty.=
=COUNT(A1:A10) will count only numbers, ignoring text.

COUNTA will count a cell containing a formula regardless of what it returns,
including an empty string ("").
COUNT will count a cell containing a formula only if it returns a number.
 
Back
Top