CountA
 

I am trying to use CountA to count non blank cells. But all the cells have
embedded metadata (user name and author) in it and therefore the countA will
return total number of rows in the range. How could I could get rid of the
embedded data?.
Please see example


B C E F I J K
1 S R* R S*
2 S R* R S*
3 S S S* S
4 S S S* S
5 S* S* S* S*
6 S* S* S* S*
7 S* S* R* S*
8 S* S* R* S*
9 S* S* R* S*
10 S* S* S* S*
11 S* S* S* S*
12 I* R* R* S*
13 R* R* R* S*
14 S S S* S
15 S
16 S S* S
17 S* S* R* S*
18 S
19 S S* S
20 S* S* R* S*
21 S S S* S
22 S* S* S S*
23 S* S* S S*
24 S S S* S
CountA: 24 24 24 25 24 24 24

--
carlee

CountA
 

Hi,

You could try using COUNTIF. Looking at your example your COUNTA function is
used in cell B25, enter the following in that cell =COUNTIF(B1:B24,"""")

Alan

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/201001/1

CountA
 

Just subtract out the cells containing unwanted data. Say we want to count
non-blank cells in A1 thru Z100, but not include "junk".

=COUNTA(A1:Z100)-COUNTIF(A1:Z100,"junk")
--
Gary''s Student - gsnu200909


"carlee" wrote:

I am trying to use CountA to count non blank cells. But all the cells have
embedded metadata (user name and author) in it and therefore the countA will
return total number of rows in the range. How could I could get rid of the
embedded data?.
Please see example


B C E F I J K
1 S R* R S*
2 S R* R S*
3 S S S* S
4 S S S* S
5 S* S* S* S*
6 S* S* S* S*
7 S* S* R* S*
8 S* S* R* S*
9 S* S* R* S*
10 S* S* S* S*
11 S* S* S* S*
12 I* R* R* S*
13 R* R* R* S*
14 S S S* S
15 S
16 S S* S
17 S* S* R* S*
18 S
19 S S* S
20 S* S* R* S*
21 S S S* S
22 S* S* S S*
23 S* S* S S*
24 S S S* S
CountA: 24 24 24 25 24 24 24

--
carlee