ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I count number of cells with info?? (https://www.excelbanter.com/excel-discussion-misc-queries/46218-how-do-i-count-number-cells-info.html)

HJK

How do I count number of cells with info??
 
I'm writing a list of numbers, in the end I wand to count how many numbers
there are, I DON'T want the sum, just to know how many ther are. How can I do
that??

Biff

Hi!

Try this:

=COUNT(A:A)

Biff

"HJK" wrote in message
...
I'm writing a list of numbers, in the end I wand to count how many numbers
there are, I DON'T want the sum, just to know how many ther are. How can I
do
that??




HJK

Thanks, it works, can I also count specifik numbers or letters??

"Biff" skrev:

Hi!

Try this:

=COUNT(A:A)

Biff

"HJK" wrote in message
...
I'm writing a list of numbers, in the end I wand to count how many numbers
there are, I DON'T want the sum, just to know how many ther are. How can I
do
that??





Anne Troy

Try this, which FIRST shows a regular COUNTIF
http://www.officearticles.com/excel/...ft_excel.h tm
************
Anne Troy
www.OfficeArticles.com

"HJK" wrote in message
...
Thanks, it works, can I also count specifik numbers or letters??

"Biff" skrev:

Hi!

Try this:

=COUNT(A:A)

Biff

"HJK" wrote in message
...
I'm writing a list of numbers, in the end I wand to count how many
numbers
there are, I DON'T want the sum, just to know how many ther are. How
can I
do
that??








All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com