Excel Count Function

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
 
E

Earl Kiosterud

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Excel does not accept text format! 0
List items based on the count given 4
Help with SUMIFS 2
Drop down list control value in vba 2
Macro to Select text from a point given to a specific word 2
Word VBA - Automatic change content of a cell in table using dropdown list 5
Macro to select and delete levels of a document 2

Top