Multiple IF and AND Statement - Need Help!

[londoneye001]

Hi - I was wondering if one of the Excel guru can correct the below formula for me? Formula it self is simple but even after the false part of the if statement I need the formula to continue to the next if statement so that next criteria can be matched. If there is a better way to do the allocation, I'm open to that as well.

Many Thanks,
Sid


=IF(AND(J4="Q1", SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"1")=0), SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"1")/13, SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"1")*AA4), IF(AND(J4="Q2", SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"2")=0), SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"2")/13, SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"2")*AA4), IF(AND(J4="Q3", SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"3")=0), SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"3")/13, SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"3")*AA4), IF(AND(J4="Q4", SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"4")=0), SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"4")/13, SUMIFS(CF.Sales,CF.Division,$H4,CF.ChainCD,$A4,CF.Period,"4")*AA4)

 

[thisoldman]

wideboydixon, I knew there was a refactoring we could do, but I was too weary to see it. Nice.