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
|
|