General discussion

Locked

excel formula

By gened_1 ·
need to know how to create a function that counts the number of celss in a columm

This conversation is currently closed to new comments.

15 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

excel formula

by jgeist 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.

Collapse -

excel formula

by gened_1 In reply to excel formula

The question was auto-closed by TechRepublic

Collapse -

excel formula

by Al Hedstrom In reply to excel formula

Also explore COUNTIF where it returns the number of cells determined by an IF condition.

Collapse -

excel formula

by gened_1 In reply to excel formula

The question was auto-closed by TechRepublic

Collapse -

excel formula

by kracquet7 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).

Collapse -

excel formula

by gened_1 In reply to excel formula

The question was auto-closed by TechRepublic

Collapse -

excel formula

by Instructor 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.

Collapse -

excel formula

by gened_1 In reply to excel formula

The question was auto-closed by TechRepublic

Collapse -

excel formula

by Kevin Holden 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.

Collapse -

excel formula

by gened_1 In reply to excel formula

The question was auto-closed by TechRepublic

Back to Windows Forum
15 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums