count rows with content in some columns
I guess that I could use something like
--(MMULT(--(AK1:AO1000<""),{1;1;1;1;1})0)
Just need to wrap it inside SUMPRODUCT:
=SUMPRODUCT(--(MMULT(--(AK1:AO1000<""),{1;1;1;1;1})0))
--
Biff
Microsoft Excel MVP
"Jack Sons" wrote in message
...
Hi all,
I want to count the number of rows (1 to 1000) that have content in
columns AK to AO. I want to do it with a formula (so no helper column or
VBA).
I guess that I could use something
like --(MMULT(--(AK1:AO1000<""),{1;1;1;1;1})0)
but I can't get it working.
Your help will be appreciated.
Jack Sons
The Netherlands
|