Thanks for the quick response. I tried that but it still is not working
properly. Would it matter that some of these cells contain formulas which
may or may not prompt a value?

"RagDyer" wrote:

Try this:

=Counta(C6:Z29)
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"stumped" wrote in message
...
I'm trying to figure out how to integrate the number of nonblank rows
within
a given array into my formula. I have tried COUNTA(ROWS(C6:Z29),1), but
that
does not give the correct result. Any help that you all may offer would
be
greatly appreciated.