excel不用透视,用公式肿么求和

=SUMPRODUCT((A1:A9=A2)*(B1:B9=$B$1),C1:C9)C1:C9为销量列