View Single Post
  #1   Report Post  
ucamms
 
Posts: n/a
Default An array formula to sum row max


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
------------------------------------------------------------------------
ucamms's Profile: http://www.excelforum.com/member.php...o&userid=19151
View this thread: http://www.excelforum.com/showthread...hreadid=382107