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