Sum by criteria in order to multiply

I know you guys can figure this out with ease. So here goes........

Let's say

50 is in C1
4|-2|1 is in B1:B3
6E|GC|6E is A1:A3

I want C1 to multiply by 12.50 (so that is C1*12.50). Easy but now I want C1*12.50 multiplied by B1:B3 but only if A1:A3 contains a value of 6E.

6E 4 50
GC -2
6E 1

What would be the formula?

Thanks in advance!

The student,

Thank you for changing your thread title
What you're looking for is the Sumif() function.
In your case, it would look like this:

Please Login or Register  to view this content.