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