Hi

I have 20 cells in a single column in a sheet called "Audits"

All the cells have a formula in them.

The formula is a simple one that reads whatever I put into a cell on a
different worksheet called "Names"

ie: =Names!A1
= Names!A2

etc etc


I would like to have a formula that counts up all the results I get in the
sheet called "Audits"

At the moment if I enter (let say) 15 names in the "Names" sheet the result
is that I see the same 15 names in the "Audits" sheet, however the COUNTA
formula returns a total of 20. SO obviously it is counting the formulas in
the range.

How can I count these results without including the formulas that dont
return a value?


Thanks in advance

John