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

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

=counta(column)-countblank(column)

"Darrell_Sarrasin via OfficeKB.com" wrote:

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

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

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


assuming the blanks from the formula is ""

You can also use COUNTIF but it has a bug in some Excel versions
with regards to the used range

if these are text you can use


=COUNTIF(A2:A101,"?")


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

--


Regards,


Peo Sjoblom

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8abae5a9538f2@uwe...
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

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

of course the last one is for numbers

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


--


Regards,


Peo Sjoblom

"Peo Sjoblom" wrote in message
...
=SUMPRODUCT(--(A2:A101<""))


assuming the blanks from the formula is ""

You can also use COUNTIF but it has a bug in some Excel versions
with regards to the used range

if these are text you can use


=COUNTIF(A2:A101,"?")


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

--


Regards,


Peo Sjoblom

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8abae5a9538f2@uwe...
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

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

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.

Sean Timmons wrote:
=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

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

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.

Peo Sjoblom wrote:
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

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

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

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8abb2cf5b1c12@uwe...
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.

Sean Timmons wrote:
=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

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

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

"Darrell_Sarrasin via OfficeKB.com" <u33691@uwe wrote in message
news:8abb451f0ed96@uwe...
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.

Peo Sjoblom wrote:
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

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

got it to work thanks.

Peo Sjoblom wrote:
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]

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

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