Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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!!! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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!!! |
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
#13
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count the number of records within a date range | New Users to Excel | |||
Excel - count the number of records between two specific dates. | Excel Worksheet Functions | |||
Count the number of AutoFiltered records | Excel Worksheet Functions | |||
How do I count the number of records within a date range? New issu | Excel Worksheet Functions | |||
Count the number of unique records | Excel Worksheet Functions |