Computing an average with multiple criteria

Originally Posted by JohnTopley

Try

Formula:

=SUMPRODUCT(($B$2:$B$97=F2)*(($C$2:$C$97)*(MOD($A$2:$A$97,4)<>0)+($D$2:$D$97)*(MOD($A$2:$A$97,4)=0))/SUMPRODUCT(--($B$2:$B$97=F2)))

That will answer the mail. Thanks, John!