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" <(E-Mail Removed)> 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(D610,">0")

--


Gary


"LaborGuyRJ" <(E-Mail Removed)> wrote in message
news:H5bRj.56970$(E-Mail Removed)...
> 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
news(E-Mail Removed)...
> =COUNTA(range)-COUNTBLANK(range)
>
>
> Gord Dibben MS Excel MVP
>
> On Sun, 27 Apr 2008 23:01:26 -0400, "LaborGuyRJ" <(E-Mail Removed)>
> 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
>>
>

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
news:(E-Mail Removed)...
> maybe something like this, depending on what your cell values are.
>
> =COUNTIF(D610,">0")
>
> --
>
>
> Gary
>
>
> "LaborGuyRJ" <(E-Mail Removed)> wrote in message
> news:H5bRj.56970$(E-Mail Removed)...
>> 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" <(E-Mail Removed)> 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
>news(E-Mail Removed)...
>> =COUNTA(range)-COUNTBLANK(range)
>>
>>
>> Gord Dibben MS Excel MVP
>>
>> On Sun, 27 Apr 2008 23:01:26 -0400, "LaborGuyRJ" <(E-Mail Removed)>
>> 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
>>>
>>
>