Hi

You can use SUMPRODUCT function, for what are you looking for.

Hope to helps you.