You want to count all the cells in a range that are "" if I understand
correctly,
=COUNTIF(A1:A20,"")
Obviously adjust the range to suit your needs,
Regards,
Alan.
"Fiona" wrote in message
...
I would like to count a column which contains formulas, some of them return
values and some of them return " "(blank). I need to count for those
return
values and I tried to use counta but unsuccessful. Could someone pls help?
Thanks in advance!
Q from Fiona