Thread: "" does not return blanck

I am using this formula in a range; +IF($B10>0,$C$3,""); if I copy paste
values this to say Data!A10:A40, why if I use counta(A10:A40), and only say
A10:A12 has data that I can see the answer of the count formula is still 41.
I want the formula to leave the cell bland if false.

Thank you

You have suggestions at your other post.

Esrei wrote:
>
> I am using this formula in a range; +IF($B10>0,$C$3,""); if I copy paste
> values this to say Data!A10:A40, why if I use counta(A10:A40), and only say
> A10:A12 has data that I can see the answer of the count formula is still 41.
> I want the formula to leave the cell bland if false.
>
> Thank you

--

Dave Peterson