Home |
Search |
Today's Posts |
#1
|
|||
|
|||
count or sum
how can I count all the occupied cells in the same column
if the cells contain text and numbers? A row 1 br1 row 2 row 3 row 4 cb2 row 5 row 6 row 7 df6 ect down to row 200. the answer should be 3 (the number of cells occupied) please help thanks rgs jerie |
#2
|
|||
|
|||
use:
=COUNTA(A:A) Regards Trevor "jerie" wrote in message ... how can I count all the occupied cells in the same column if the cells contain text and numbers? A row 1 br1 row 2 row 3 row 4 cb2 row 5 row 6 row 7 df6 ect down to row 200. the answer should be 3 (the number of cells occupied) please help thanks rgs jerie |
#3
|
|||
|
|||
Jerie,
=countif(a1:a200,"") will return the total number of blanks thanks......jaya "jerie" wrote: how can I count all the occupied cells in the same column if the cells contain text and numbers? A row 1 br1 row 2 row 3 row 4 cb2 row 5 row 6 row 7 df6 ect down to row 200. the answer should be 3 (the number of cells occupied) please help thanks rgs jerie |
#4
|
|||
|
|||
Hi!
Will there be any enties that are only numbers? Is there always only a single digit? Are the digits always the last character? Will there be any entries that are all letters? row 1 br1 row 2 101 row 3 k22 row 4 cb2 row 5 44s row 6 xxx row 7 df6 Biff -----Original Message----- how can I count all the occupied cells in the same column if the cells contain text and numbers? A row 1 br1 row 2 row 3 row 4 cb2 row 5 row 6 row 7 df6 ect down to row 200. the answer should be 3 (the number of cells occupied) please help thanks rgs jerie . |
#5
|
|||
|
|||
jerie
=countif(a1:a200,"""") will return the number of cells containing text =countif(a1:a200,"0") will return the number of cells containing +numeric if you combine these two criteria with +, will return both text and +numeric thanks....jaya "jerie" wrote: how can I count all the occupied cells in the same column if the cells contain text and numbers? A row 1 br1 row 2 row 3 row 4 cb2 row 5 row 6 row 7 df6 ect down to row 200. the answer should be 3 (the number of cells occupied) please help thanks rgs jerie |
#6
|
|||
|
|||
=COUNTA(A1:A10) will return the count of cells with text or numbers, and also cells containing error values and cells containing a formula that is returning a result of "". On Sat, 5 Mar 2005 00:43:01 -0800, "Jaya" wrote: jerie =countif(a1:a200,"""") will return the number of cells containing text =countif(a1:a200,"0") will return the number of cells containing +numeric if you combine these two criteria with +, will return both text and +numeric thanks....jaya "jerie" wrote: how can I count all the occupied cells in the same column if the cells contain text and numbers? A row 1 br1 row 2 row 3 row 4 cb2 row 5 row 6 row 7 df6 ect down to row 200. the answer should be 3 (the number of cells occupied) please help thanks rgs jerie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Count number to reach a cumulative value | Excel Worksheet Functions | |||
Count If Formula | Excel Worksheet Functions | |||
count based on two fields - need quickly | Excel Worksheet Functions |