Thread: How to write the SUM of two MAX numbers in four or more than four cells
View Single Post
  #2  
Old April 29th, 2010, 02:01 PM posted to microsoft.public.excel.newusers
Don Guillett[_2_]
external usenet poster
  
Posts: 607
Default How to write the SUM of two MAX numbers in four or more than four cells
=LARGE(R2:R22,1)+LARGE(R2:R22,2)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Intel" wrote in message
...

How to write the SUM of two MAX numbers in four or more than four cells

like there are Five tests out of which only Maximum two are selected
for final Result what formula or expression should I use

I m Waiting for Ur Reply




--
Intel