But \ in stead of ; is new for me.
Can I excpect that also in other cases?

I have no idea! I work strictly with U.S. English versions of Excel.

In U.S. English versions semi-colons denote a vertical array: {1;1;1;1;1}.

Commas are used for a horizontal array: {1,1,1,1,1}.


--
Biff
Microsoft Excel MVP


"Jack Sons" wrote in message
...
T,

Works like a charm, many thanks.

Never thought of MMULT and certainly not of using it in this way. Very
useful if a column in the range is to be excluded, e.g. with (1;1;1;0;1}

By the way, my (Dutch) version of Excel2k shows {1\1\1\1\1}in stead of
{1;1;1;1;1}. I know the difference between European and USA version with
respect to ; in stead of , in formulas. But \ in stead of ; is new for me.
Can I excpect that also in other cases?

Jack.


"T. Valko" schreef in bericht
...
How many rows of data do you have?

This is limited to no more than 5461 rows.

=SUMPRODUCT(--(MMULT(--(AK2:AO10<""),{1;1;1;1;1})0),F2:F10)

--
Biff
Microsoft Excel MVP


"Jack Sons" wrote in message
...
Hi all,

I want to sum in column F those cells for which in their row one or more
cells in the range AK:AO is not empty.
I tried but did not succeed. Possibly whith an array entered formula?
(not VBA)
Your help will be appreciated.

Jack Sons
The Netherlands