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