Quote Originally Posted by nflsales View Post
=sum(index((((b1:b9=d9)+(b1:b9=e9)+(b1:b9=f9))>0)*(a1:a9),0))
try this
and freeze the column ranges as you need ..