Hi,
Maybe you can use sumproduct()

If your above data starts with Brand in A1 then some thing like this:

=SUMPRODUCT(--(A2:A9=A11),--(B2:B9=B11),--(C2:C9=C11),D2:D9)*D11

Where the brand is in A11, the Product Name in B11 and the MC Name in
C11 and quantity in D11

Reagards,
Bondi