General discussion
-
CreatorTopic
-
June 12, 2000 at 6:40 am #2074590
excel formula
Lockedby gened_1 · about 21 years, 11 months ago
need to know how to create a function that counts the number of celss in a columm
Topic is locked -
CreatorTopic
All Comments
-
AuthorReplies
-
-
June 12, 2000 at 6:47 am #3778736
excel formula
by jgeist · about 21 years, 11 months ago
In reply to excel formula
Are they blank or do they contain numbers or formulas? If they’re blank, use COUNTBLANK. There’s also COUNT and COUNTA which can be found in the Function Wizard.
-
September 20, 2000 at 7:04 pm #3754477
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
The question was auto-closed by TechRepublic
-
-
June 12, 2000 at 11:55 am #3778636
excel formula
by al hedstrom · about 21 years, 11 months ago
In reply to excel formula
Also explore COUNTIF where it returns the number of cells determined by an IF condition.
-
September 20, 2000 at 7:04 pm #3754478
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
The question was auto-closed by TechRepublic
-
-
June 12, 2000 at 2:17 pm #3778589
excel formula
by kracquet7 · about 21 years, 11 months ago
In reply to excel formula
If all the cells you want to count have some type of data, the formula should be =COUNTA(range)
However, if you want to count blanks, the formula would be =countblank(range)
If this doesn’t work, please let us know what is in the cells (numeric data, alpha data, blanks, or formulas).
-
September 20, 2000 at 7:04 pm #3754479
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
The question was auto-closed by TechRepublic
-
-
June 13, 2000 at 9:11 am #3778277
excel formula
by instructor · about 21 years, 11 months ago
In reply to excel formula
The “count” command should work depending if you are counting cells with data or if they are empty. There is also a shortcut you can use on the fly, just highlight the cells you want to count, then on the right side of the status bar there is an “autocalculate” box. Right click on the box and select “count”. That box will then give you a total of the number of cells selected. However, this total will not be inserted in your spreadsheet.
-
September 20, 2000 at 7:04 pm #3754480
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
The question was auto-closed by TechRepublic
-
-
June 14, 2000 at 4:00 am #3777022
excel formula
by kevin holden · about 21 years, 11 months ago
In reply to excel formula
Hello,
All of the answers are good, but we all have the same problem of the fact that we do not have all the specific details that we need. If need a count of the cells no matter what they contain (numbers, text, formulas, or are blank). You can use this formula, It will basically just count the number of cells and adjust itself automatically when rows are added or deleted.=(COUNTA(C4:C23))+(COUNTBLANK(C4:C23))
Of course you must change the range references to meet you desired column.-
September 20, 2000 at 7:04 pm #3754481
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
The question was auto-closed by TechRepublic
-
-
July 9, 2000 at 12:51 am #3766189
excel formula
by khinton · about 21 years, 10 months ago
In reply to excel formula
try this:
=COUNTA(D4:D9)+COUNTBLANK(D4:D9)
where d4:d9 is enter your own range
this will count all regardles of contents
if you want to see cells with entries use =counta(range) or =countblank(range)to count blank cells.
kevin-
September 20, 2000 at 7:04 pm #3754482
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
The question was auto-closed by TechRepublic
-
-
July 27, 2000 at 7:26 am #3772865
excel formula
by pdsmith · about 21 years, 10 months ago
In reply to excel formula
If you are looking for a count of cells on a conditional basis, for example if you want to count cells that only have a YES or a 1 in them. You can use a COUNTIF formula.
=COUNTIF(A1:A10, “YES”)or
=COUNTIF(A1:A10, 1)This will give you the count of the cells A1 through A10 that are equal to “YES” or 1.
-
September 20, 2000 at 7:04 pm #3754483
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
The question was auto-closed by TechRepublic
-
-
September 20, 2000 at 7:04 pm #3754476
excel formula
by gened_1 · about 21 years, 8 months ago
In reply to excel formula
This question was auto closed due to inactivity
-
-
AuthorReplies