counting only results in a column of formulas

[LaborGuyRJ]

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

 

[Gord Dibben]

=COUNTA(range)-COUNTBLANK(range)


Gord Dibben MS Excel MVP

 

[Gary Keramidas]

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

=COUNTIF(D610,">0")

 

[LaborGuyRJ]

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

 

[LaborGuyRJ]

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

 

[Gord Dibben]

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


Gord