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

P

partyzanx2019-04-04 02:31:12

How to make the printable area stick to the center of the sheet in EXCEL, and not to the left edge? 1Reply

I

Igor Raskin2019-04-07 21:53:10

How to set relative path for win32com excel object in python? 1Reply

U

Username2016-11-15 20:42:32

How to display a table excluding some rows? 2Reply

H

HDDx2019-04-14 00:05:55

How to use Apache POI to insert a picture into Excel in Android Studio via button? 0Reply

S

S_Morello2019-04-18 08:43:35

How to make a drop down list of sheets followed by autocomplete from the selected sheet? 2Reply

Didn't find what you were looking for?

Ask your question