What formula should I use to count a number of records?

  • Thread starter Thread starter Princesshera1
  • Start date Start date
P

Princesshera1

I have a list of computers....I want to count the total number of computers
in my list. I'm going nuts...it should be simple, but I can't figure it out!!!
 
Princesshera1 said:
I have a list of computers....I want to count the total number of computers
in my list. I'm going nuts...it should be simple, but I can't figure it
out!!!
Click to expand...


Err COUNT?
 
I have version 2003......I haven't gotten any error messages.....I just want
to count the total number of computers I have listed.
 
Princesshera1 said:
I have version 2003......I haven't gotten any error messages.....I just
want
to count the total number of computers I have listed.
Click to expand...


That's what the Excel COUNT function will do.......Click on the fx button
and choose COUNT. It will walk you through the process.
 
assuming you have the list of computers in A2 to A100
try
=COUNT(A2:A100) or
or if there are blank cells in between
=COUNTA(A2:A100)
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
Gordon said:
That's what the Excel COUNT function will do.......Click on the fx button
and choose COUNT. It will walk you through the process.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)

I am using text as my criteria, not numbers. I typed in the following formula : =countif(b2:b56,"Optiplex 755") using the process given. When I tried it in the actual cell and hit the enter key to show the program I was done typing, the count was not listed, the formula was.
Click to expand...
 
COUNT will count only numeric cells.

COUNTA will count non-blank cells.


Gord Dibben MS Excel MVP
 
Change the format to General then re-enter the formula.

F2 then ENTER

But use the COUNTA function.

COUNT function counts only numeric cells.


Gord Dibben MS Excel MVP
 
Looks like you want the COUNTIF function

=COUNTIF(B2:B56,"Optiplex 755")


Gord Dibben MS Excel MVP
 
Mixed interpretations of your needs.

To count all computers use the COUNTA function

To count specific computers use the COUNTIF function.


Gord
 
COUNTA meaning cells with text?????? Those are the kinds of cells I am
trying to count.
 
See my other posts for different interpretations.

But yes.............COUNTA counts all cells with anything in them. Text or
numbers.


Gord
 
to count the number of cells contain text, use
=COUNTIF(A2:A14,"*")

COUNTA is use to count non blank cells
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
Back
Top