Count blank cells and cells with text
RK,
That should be a constant....unless your range is dynamic. But, to answer
your question, there is no single worksheet function that will work the way
you want it to, unless you have a single row or column, in which case
COLUMNS or ROWS will work as well.
Bernie
"rk0909" wrote in message
...
Is there a function which adds up both blank cells and cells with text?
I
know I can do it with countA + countblank, but one function would work
better.
thanks much for your help.
RK
|