Ooops, that second one needs an extra
paren: =SUMPRODUCT((($C$3:$C$320=K3)+($C$3:$C$320=K4))*$E $3:$E$320*$H$3:$H$320)/SUMIF($C$3:$C$320,K3,$E$3:$ E$320) Bernie "Bernie Deitrick" deitbe @ consumer dot org wrote in message ... For multiple criteria, use this style for AND requirements =SUMPRODUCT(($C$3:$C$320=K3)*($D$3:$D$320=L3)*$E$3 :$E$320*$H$3:$H$320)/SUMIF($C$3:$C$...