How to write this formula in excel?

A

Artem Matyashov2017-04-12 18:31:50

excel

Artem Matyashov, 2017-04-12 18:31:50

It is necessary to multiply each row (from 3 to 8) of column B with the corresponding row in column C and sum the resulting products. You cannot select a separate column for the product result.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

E

Elvis, 2017-04-12
@turboj55

Like this:
SUMPRODUCT(B3:B8;C3:C8)

Similar questions

I

Igor Maksimov2018-02-06 13:01:05

Microsoft Excel. How to make a transfer through 2 cells? 1Reply

V

vladeol2018-02-08 18:54:10

How can I get information from cells with data by condition? 1Reply

A

Andrey2015-10-08 14:45:12

How to bypass xls file allowable by PHPExcel parser with non-fixed number of vertical fields? 1Reply

N

Nighmer2020-04-23 13:04:15

How to remove part of a request? 0Reply

W

whoisdoctors2018-02-15 15:38:38

How to filter a table by two columns? 1Reply

Didn't find what you were looking for?

Ask your question