Question dividing multiple Sumifs

[cjmueller08]

I have a formula designed to add two sumifs together and then divide that total by an additional two sum ifs added together. Getting a result but it's not accurate. I think I may be missing bracketing the first sum ifs additions and correctly dividing by the other two sum ifs. Formula below. Thanks for your help,

=IFERROR(1-((SUMIFS(CustSls!F:F,CustSls!B:B,">799",CustSls!B:B,"<900",CustSls!D:D,A21)+SUMIFS(CustSls!F:F,CustSls!B:B,">100",CustSls!B:B,"<486",CustSls!D:D,A21)/SUMIFS(CustSls!H:H,CustSls!B:B,">799",CustSls!B:B,"<900",CustSls!D:D,A21)+SUMIFS(CustSls!H:H,CustSls!B:B,">100",CustSls!B:B,"<486",CustSls!D:D,A21))),"-")

 

[jasonb75]

See if this gives the expected result.

=IFERROR(1-(SUMIFS(CustSls!F:F,CustSls!B:B,">799",CustSls!B:B,"<900",CustSls!D:D,A21)+SUMIFS(CustSls!F:F,CustSls!B:B,">100",CustSls!B:B,"<486",CustSls!D:D,A21))/(SUMIFS(CustSls!H:H,CustSls!B:B,">799",CustSls!B:B,"<900",CustSls!D:D,A21)+SUMIFS(CustSls!H:H,CustSls!B:B,">100",CustSls!B:B,"<486",CustSls!D:D,A21)),"-")

 

[cjmueller08]

Thank you!!