SUM OF LARGE NUMBERS IN DIFFERENT SHEETS

[nskatoch]

There are six sheets namely UT1,UT2,UT3,UT4,UT5,UT6.
I have used the following formula for sum of large number as:
=IFERROR(SUM(LARGE(UT1:UT6!C6,1), (LARGE(UT1:UT6!C6,2), (LARGE(UT1:UT6!C6,3), (LARGE(UT1:UT6!C6,4)),””)
When I press the Enter button, it turns as:
=IFERROR(SUM(LARGE(UT1:’UT6’!C6,1), (LARGE(UT1:’UT6’!C6,2), (LARGE(UT1:’UT6’!C6,3), (LARGE(UT1:’UT6’!C6,4)),””)
And retuns blank.
If type this formula as
=IFERROR(SUM(LARGE(‘UT1:UT6’!C6,1), (LARGE(‘UT1:UT6’!C6,2), (LARGE(‘UT1:UT6’!C6,3), (LARGE(‘UT1:UT6’!C6,4)),””)
It returns wrong value.
Please suggest me.

 

[Paul Ked]

=IFERROR(SUM(LARGE('UT1:UT6'!C6,1),LARGE('UT1:UT6'!C6,2), LARGE('UT1:UT6'!C6,3), LARGE('UT1:UT6'!C6,4)),"")

 

[nskatoch]

Thanks sir
But If i have inserted one or more sheets between existing sheets then this formula returns wrong value
i.e. UT1,UT2,UT3,AT1,AT2,UT4,UT5,UT6.

 

[Paul Ked]

Yes! It will take AT1 and AT2 into account. If you don't want them in your equation then either move them outside of the UT range or make references to the cells you need on one sheet and do the calculation there.