sumif? array enter?
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
|