Can anyone shorten this formula please. Basically all it
does is gives me an average of the figures in Column "W"
depending on the number of times that product appears
in "R" column
=IF(ISERROR(SUM(SUMIF($R$5:$R$9,R62,$W$5:$W$9),SUMIF
($R$22:$R$26,R62,$W$22:$W$26),SUMIF
($R$39:$R$43,R62,$W$39:$W$43))/COUNTIF
($R$5:$R$43,R62)),0,SUM(SUMIF
($R$5:$R$9,R62,$W$5:$W$9),SUMIF
($R$22:$R$26,R62,$W$22:$W$26),SUMIF
($R$39:$R$43,R62,$W$39:$W$43))/COUNTIF($R$5:$R$43,R62))
thanks
Pete
Bookmarks