Counta

[Darrell_Sarrasin via OfficeKB.com]

I hve been fighting with this for the last week or so. I have a column which
has the potential to show 100 items. it is a basically filled in with a
statement that shows the cell as blank if there is nothing in it.

The issue I am having is that I want to count the amount of entries, but it
keeps counting all the cells with a formula in it.

Can I get help on how to make it so it ignores the cells with a formula

 

[Darrell_Sarrasin via OfficeKB.com]

I dont think that I have explained it correctly
I have multiple work sheets. On worksheet A I have a chart where someone
fills in the last name in one column and the first in another column.

To save time I made it so that on worksheet B I have copied the results into
cells B10:B109. The issue thou that i am running into is that I need to
count how many are in the class so I am counting the last names that show up
in B10:B109.

Right now because I dont want a 0 to show up in the range I am using the
formula

=IF('Control Tab'!B2=""," ",'Control Tab'!B2) with Control tab being
Worksheet A

when I try to count on Worksheet B the entries, it it telling me 100 because
all of the cells has something in it. I just want to be able to count the
results which is in text when a cell is filled in.

of course the last one is for numbers

=COUNTIF(A2:A101,"<"&99^99)

=SUMPRODUCT(--(A2:A101<>""))

[quoted text clipped - 19 lines]

 

[Peo Sjoblom]

It works for me. What is not working. Are you using spaces " " instead of
""
in your formulas to designate blanks?

Another formula that works is

=SUMPRODUCT(--(LEN(A1:A10)>0))

Regardless, Sean's formula works

--


Regards,


Peo Sjoblom

Sorry it does not work

THe column has a formula sitting in it so that there is nothing displayed
if
what its pulling from is blank.

Need something to ignore the formula in each cell unless there is output
printed. and hte output is text.

=counta(column)-countblank(column)

I hve been fighting with this for the last week or so. I have a column
which
has the potential to show 100 items. it is a basically filled in with a

[quoted text clipped - 4 lines]

Can I get help on how to make it so it ignores the cells with a formula

 

[Peo Sjoblom]

Did you try any of the formulas, all the formulas I posted work if you want
to count
cells that are not empty with formulas in them.

COUNTIF(A1:A100,"?")

will not include cells with formulas that returns ""
and will only count if the result is text






--


Regards,


Peo Sjoblom

I dont think that I have explained it correctly
I have multiple work sheets. On worksheet A I have a chart where someone
fills in the last name in one column and the first in another column.

To save time I made it so that on worksheet B I have copied the results
into
cells B10:B109. The issue thou that i am running into is that I need to
count how many are in the class so I am counting the last names that show
up
in B10:B109.

Right now because I dont want a 0 to show up in the range I am using the
formula

=IF('Control Tab'!B2=""," ",'Control Tab'!B2) with Control tab being
Worksheet A

when I try to count on Worksheet B the entries, it it telling me 100
because
all of the cells has something in it. I just want to be able to count the
results which is in text when a cell is filled in.

of course the last one is for numbers

=COUNTIF(A2:A101,"<"&99^99)

=SUMPRODUCT(--(A2:A101<>""))

[quoted text clipped - 19 lines]

Can I get help on how to make it so it ignores the cells with a formula

 

[Darrell_Sarrasin via OfficeKB.com]

got it to work thanks.

Did you try any of the formulas, all the formulas I posted work if you want
to count
cells that are not empty with formulas in them.

COUNTIF(A1:A100,"?")

will not include cells with formulas that returns ""
and will only count if the result is text

I dont think that I have explained it correctly
I have multiple work sheets. On worksheet A I have a chart where someone

[quoted text clipped - 27 lines]