Assuming that A1:T1000 contains your data, try...
=SUMPRODUCT(SUBTOTAL(4,OFFSET(A1:T1000,ROW(A1:T100 0)-MIN(ROW(A1:T1000)),0,1)))
Hope this helps!
ucamms Wrote:
I have a data range of 1000 rows and 20 columns. I need a sum of the
maximum number of each rows. I usually add another column to calculate
row max. But is it possible to eliminate this intermediate step and
just use a single cell array formula to return the sum of row maxes?
Thanks
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=382107