Since the formula has to be array entered you can save a few keystokes and
just use SUM:

=SUM(--(MMULT(--(C6:Z29<""),TRANSPOSE(COLUMN(C6:Z29))^0)0))


--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this array formula** :

=SUMPRODUCT(--(MMULT(--(C6:Z29<""),TRANSPOSE(COLUMN(C6:Z29))^0)0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"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.