Thread: How to sum of two max figures out of five and four figures
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How to sum of two max figures out of five and four figures
Try this

=SUM(LARGE(A1:A60,ROW(INDIRECT("1:2"))))+SUM(LARGE (B1:B60,ROW(INDIRECT("1:2"))))

This will do columns A and B, add more columns as necessary.

Mike

"Arshad" wrote:

I need to get sum of two maximum figures from five and four columns. Please
give me the formula in Excel Sheet.

Thanks.


Arshad
Reply With QuoteReply With Quote