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

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!!!

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

"Princesshera1" wrote in message
...
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!!!


Err COUNT?

--
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)

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

I have version 2003......I haven't gotten any error messages.....I just want
to count the total number of computers I have listed.

"Gordon" wrote:

"Princesshera1" wrote in message
...
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!!!


Err COUNT?

--
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)

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

"Princesshera1" wrote in message
...
I have version 2003......I haven't gotten any error messages.....I just
want
to count the total number of computers I have listed.



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)

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

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



"Princesshera1" wrote:

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!!!

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

"Gordon" wrote:

"Princesshera1" wrote in message
...
I have version 2003......I haven't gotten any error messages.....I just
want
to count the total number of computers I have listed.



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.

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

COUNT will count only numeric cells.

COUNTA will count non-blank cells.


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:32:06 -0700, Francis
wrote:

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)

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

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

On Wed, 1 Apr 2009 10:41:01 -0700, Princesshera1
wrote:



"Gordon" wrote:

"Princesshera1" wrote in message
...
I have version 2003......I haven't gotten any error messages.....I just
want
to count the total number of computers I have listed.



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.

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

Looks like you want the COUNTIF function

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


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:41:01 -0700, Princesshera1
wrote:



"Gordon" wrote:

"Princesshera1" wrote in message
...
I have version 2003......I haven't gotten any error messages.....I just
want
to count the total number of computers I have listed.



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.

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

Mixed interpretations of your needs.

To count all computers use the COUNTA function

To count specific computers use the COUNTIF function.


Gord

On Wed, 01 Apr 2009 11:08:00 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

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

On Wed, 1 Apr 2009 10:41:01 -0700, Princesshera1
wrote:



"Gordon" wrote:

"Princesshera1" wrote in message
...
I have version 2003......I haven't gotten any error messages.....I just
want
to count the total number of computers I have listed.



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.

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

COUNTA meaning cells with text?????? Those are the kinds of cells I am
trying to count.

"Gord Dibben" wrote:

COUNT will count only numeric cells.

COUNTA will count non-blank cells.


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:32:06 -0700, Francis
wrote:

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)

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

See my other posts for different interpretations.

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


Gord

On Wed, 1 Apr 2009 11:22:05 -0700, Princesshera1
wrote:

COUNTA meaning cells with text?????? Those are the kinds of cells I am
trying to count.

"Gord Dibben" wrote:

COUNT will count only numeric cells.

COUNTA will count non-blank cells.


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:32:06 -0700, Francis
wrote:

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)

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

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



"Princesshera1" wrote:

COUNTA meaning cells with text?????? Those are the kinds of cells I am
trying to count.

"Gord Dibben" wrote:

COUNT will count only numeric cells.

COUNTA will count non-blank cells.


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 10:32:06 -0700, Francis
wrote:

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)