Can you solve this question by using the function SUMPRODUCT?

In the office, people are using EXCEL. But have you ever used the function SUMPRODUCT?

I'll give you a question.

Please use SUMPRODUCT..

See the pic-1

Can you solve the total?

In my experience, many people use simple way such as the pic-2

I am serious. Yes, lots of people do it.

Now, let's use the function SUMPRODUCT.

see below.

Do you think it would be better than other one?