Can anyone show me a formula to sum a product of two arrays only when there
is a match. Suppose I want to add up the product of A and C for Apple
(answer 3%) and Orange (answer 3.5%)

eg.
A B C
1% Apple 100%
2% Orange 50%
3% Pear 25%
4% Apple 50%
5% Orange 50%