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),SUM IF
($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