Help to make Fomula sorter

[sbv1986]

Hi all
I have to caculate alot of cell, One of formula belove.

=(IF(SUMIF('ky1'!$C$1:$C$9988;"50";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"50";'ky1'!$H$1:$H$9988)>0;SUMIF('ky1'!$C$1:$C$9988;"50";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"50";'ky1'!$H$1:$H$9988);0)+IF(SUMIF('ky1'!$C$1:$C$9988;"52";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"52";'ky1'!$H$1:$H$9988)>0;SUMIF('ky1'!$C$1:$C$9988;"52";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"52";'ky1'!$H$1:$H$9988);0)+IF(SUMIF('ky1'!$C$1:$C$9988;"51";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"51";'ky1'!$H$1:$H$9988)>0;SUMIF('ky1'!$C$1:$C$9988;"51";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"51";'ky1'!$H$1:$H$9988);0)+IF(SUMIF('ky1'!$C$1:$C$9988;"56";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"56";'ky1'!$H$1:$H$9988)>0;SUMIF('ky1'!$C$1:$C$9988;"56";'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988;"56";'ky1'!$H$1:$H$9988);0))/1000000

Can you give me any medthod to sorter formula? Thanks

 

[6StringJazzer]

What version of Excel do you use?

 

[sbv1986]

@6StringJazzer My Office is 2010, another computer in my Company 2013 and later

 

[6StringJazzer]

=(MAX(SUMIF('ky1'!$C$1:$C$9988,"50",'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988,"50",'ky1'!$H$1:$H$9988),0)+
  MAX(SUMIF('ky1'!$C$1:$C$9988,"52",'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988,"52",'ky1'!$H$1:$H$9988),0)+
  MAX(SUMIF('ky1'!$C$1:$C$9988,"51",'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988,"51",'ky1'!$H$1:$H$9988),0)+
  MAX(SUMIF('ky1'!$C$1:$C$9988,"56",'ky1'!$I$1:$I$9988)-SUMIF('ky1'!$C$1:$C$9988,"56",'ky1'!$H$1:$H$9988),0))/1000000

Cannot test without your data.

 

[sbv1986]

Thanks for your help