I've tried to break this formula up into defined names but it is not working
properly. Does anyone have any suggestions how I can get around the 30
argument limitation of the SUM function? Each argument is multiplying a
number times a percentage.

Thanks!

Randy

=SUM(($C22*$C20),($D22*$D20),($E22*$E20),($F22*$F2 0),($G22*$G20),($H22*$H20),($I22*$I20),($J22*$J20) ,($K22*$K20),($L22*$L20),($M22*$M20),($N22*$N20),( $O22*$O20),($P22*$P20),($Q22*$Q20),($R22*$R20),($S 22*$S20),($T22*$T20),($U22*$U20),($V22*$V20),($W22 *$W20),($X22*$X20),($Y22*$Y20),($X22*$X20),($AA22* $AA20),($AB22*$AB20),($AC22*$AC20),($AD22*$AD20),( $AE22*$AE20),($AF22*$AF20))/SUM($C20:AF20)