counting nonblank rows
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.
|