Hello, I have Windows XP Pro and Excel 2007.
I have three columns with 20 lines each. Each has a formula that is looking
to a value in another worksheet. When the other worksheet doesn't have an
entry, neither does my sheet, but the formula is still present.

When I try to get a count of the results of the link it counts both the link
and the formula so I always get 20 for the counta().
Can anyone help with a function to count only the result of the formula for
a true accounting of the actual fields with data in them.

Thank You
BobR

=COUNTA(range)-COUNTBLANK(range)


Gord Dibben MS Excel MVP

On Sun, 27 Apr 2008 23:01:26 -0400, "LaborGuyRJ" wrote:

Hello, I have Windows XP Pro and Excel 2007.
I have three columns with 20 lines each. Each has a formula that is looking
to a value in another worksheet. When the other worksheet doesn't have an
entry, neither does my sheet, but the formula is still present.

When I try to get a count of the results of the link it counts both the link
and the formula so I always get 20 for the counta().
Can anyone help with a function to count only the result of the formula for
a true accounting of the actual fields with data in them.

Thank You
BobR

Thanks for responding. Unfortunately when I use the Countblank(range) it
shows no cells are blank. I'm afraid that it's counting the forumlas too? Or
am I doing something wrong, copied your formula exactly.
Thanks Bob


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
=COUNTA(range)-COUNTBLANK(range)


Gord Dibben MS Excel MVP

On Sun, 27 Apr 2008 23:01:26 -0400, "LaborGuyRJ"
wrote:

Hello, I have Windows XP Pro and Excel 2007.
I have three columns with 20 lines each. Each has a formula that is
looking
to a value in another worksheet. When the other worksheet doesn't have an
entry, neither does my sheet, but the formula is still present.

When I try to get a count of the results of the link it counts both the
link
and the formula so I always get 20 for the counta().
Can anyone help with a function to count only the result of the formula
for
a true accounting of the actual fields with data in them.

Thank You
BobR

If you had a formula like =IF(Sheet1!A1="","",Sheet1!A1) and A1 was blank, the
formula would return "" and countblank would find it.

From your original description, I thought that was what you had.

I guess I was thrown off by

When the other worksheet doesn't have an
entry, neither does my sheet, but the formula is still present.


Gord

On Sun, 27 Apr 2008 23:33:07 -0400, "LaborGuyRJ" wrote:

Thanks for responding. Unfortunately when I use the Countblank(range) it
shows no cells are blank. I'm afraid that it's counting the forumlas too? Or
am I doing something wrong, copied your formula exactly.
Thanks Bob


"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
=COUNTA(range)-COUNTBLANK(range)


Gord Dibben MS Excel MVP

On Sun, 27 Apr 2008 23:01:26 -0400, "LaborGuyRJ"
wrote:

Hello, I have Windows XP Pro and Excel 2007.
I have three columns with 20 lines each. Each has a formula that is
looking
to a value in another worksheet. When the other worksheet doesn't have an
entry, neither does my sheet, but the formula is still present.

When I try to get a count of the results of the link it counts both the
link
and the formula so I always get 20 for the counta().
Can anyone help with a function to count only the result of the formula
for
a true accounting of the actual fields with data in them.

Thank You
BobR

maybe something like this, depending on what your cell values are.

=COUNTIF(D6:D10,"0")

--


Gary


"LaborGuyRJ" wrote in message
.. .
Hello, I have Windows XP Pro and Excel 2007.
I have three columns with 20 lines each. Each has a formula that is looking to
a value in another worksheet. When the other worksheet doesn't have an entry,
neither does my sheet, but the formula is still present.

When I try to get a count of the results of the link it counts both the link
and the formula so I always get 20 for the counta().
Can anyone help with a function to count only the result of the formula for a
true accounting of the actual fields with data in them.

Thank You
BobR

My thanks to all.
Gary that was the magic cookie. It's now registering what I need. I have
dates in the values and this formula is exact.
Thanks to all
Bob


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
maybe something like this, depending on what your cell values are.

=COUNTIF(D6:D10,"0")

--


Gary


"LaborGuyRJ" wrote in message
.. .
Hello, I have Windows XP Pro and Excel 2007.
I have three columns with 20 lines each. Each has a formula that is
looking to a value in another worksheet. When the other worksheet doesn't
have an entry, neither does my sheet, but the formula is still present.

When I try to get a count of the results of the link it counts both the
link and the formula so I always get 20 for the counta().
Can anyone help with a function to count only the result of the formula
for a true accounting of the actual fields with data in them.

Thank You
BobR