cjmueller08
New Member
- Joined
- Aug 28, 2009
- Messages
- 17
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))),"-")
=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))),"-")