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

  • Follow


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
0
Reply Intel 4/29/2010 11:24:36 AM

=LARGE(R2:R22,1)+LARGE(R2:R22,2)

-- 
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett@gmail.com
"Intel" <Intel.61f3552@excelbanter.com> wrote in message 
news:Intel.61f3552@excelbanter.com...
>
> 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 

0
Reply Don 4/29/2010 1:01:08 PM


1 Replies
357 Views

(page loaded in 0.049 seconds)


Reply: