How can add best two integers from different three sheets

[nskatoch]

How can add best two integers from different three worksheets.

I have three sheets PWT1,PWT2,PWT3. How i can add best two integers of same cell oo three diffent sheets.
I have used following formula but it not works:

=IFERROR(SUM(LARGE('PWT1'!C6:'PWT2'!C6:'PWT3'!C6,1),LARGE('PWT1'!C6:'PWT2'!C6:'PWT3'!C6,2)),"")

 

[oldbrewer]

=if(and(ptw1!C6<ptw2!C6,ptw1!C6<ptw3!c6,ptw2!C6+ptw3!C6............

you now need to see if ptw2!c6 is the smallest, if it is add 1 and 3, if it is not you know 3 is smallest so add 1 and 2

 

[nskatoch]

Thanks sir,
But it not works.

 

[Rick Rothstein]

How can add best two integers from different three worksheets.

I have three sheets PWT1,PWT2,PWT3. How i can add best two integers of same cell oo three diffent sheets.
I have used following formula but it not works:

=IFERROR(SUM(LARGE('PWT1'!C6:'PWT2'!C6:'PWT3'!C6,1),LARGE('PWT1'!C6:'PWT2'!C6:'PWT3'!C6,2)),"")

I am not sure you need the IFERROR function call (if you do, add it back in). Give this formula a try...

=MAX(PWT1!C6,PWT2!C6,PWT3!C6)+MEDIAN(PWT1!C6,PWT2!C6,PWT3!C6)

 

[AlphaFrog]

Try this if the sheets are consecutive...

SUM(LARGE(PWT1:PWT3!C6,1),LARGE(PWT1:PWT3!C6,2))



Or this...

SUM(PWT1!C6,PWT2!C6,PWT3!C6)-MIN(PWT1!C6,PWT2!C6,PWT3!C6)

 

[oldbrewer]

my post was destroyed by the system it had "<" signs in it

 

[oldbrewer]

=if(and(ptw1!C6<ptw2!c6,ptw1!c6<ptw3!c6,ptw2!c6+ptw3!c6............
< ptw2!C6,ptw1!c6 < ptw3!C6), ptw2!C6+ptw3!C6,......................
you now need to see if ptw2!c6 is the smallest, if it is add 1 and 3, if it is not you know 3 is smallest so add 1 and 2</ptw2!c6,ptw1!c6<ptw3!c6,ptw2!c6+ptw3!c6............

 

[nskatoch]

Thanks sir

 

[oldbrewer]

glad to help