An array formula to sum row max

[ucamms]

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]

Assuming that A1:T1000 contains your data, try...

=SUMPRODUCT(SUBTOTAL(4,OFFSET(A1:T1000,ROW(A1:T1000)-MIN(ROW(A1:T1000)),0,1)))

Hope this helps!

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

[ucamms]

It wooked. Very clever. I didn't think of using offset() and row() combination.

Thank you for helping.