View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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