# Beginner formular question

#### richiwatts

##### Board Regular
I want cell B10 to show the total of:

(B2 X C2) + (B3 X C3) + (B4 X C4) + (B5 X C5) + (B6 X C6) + (B7 X C7) + (B8 X C8) =

What do I need to put in B10 for this to be calculates?

Thanks
Rich

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### fairwinds

##### MrExcel MVP
Hi,

Try:

=SUMPRODUCT(B2:B8,C2:C8)

#### richiwatts

##### Board Regular
I get error in formular

What error?

#### richiwatts

##### Board Regular

I am translating it from swedish so it might not be the same in English but I tyhink it just says:

Formula error

#### richiwatts

##### Board Regular
I did it the long way

=B2*C2
=B3*C3

and then added them all up.

Thanks

#### fairwinds

##### MrExcel MVP
In Swedish it is:

=PRODUKTSUMMA(B2:B8;C2:C8)

Replies
4
Views
145
Replies
8
Views
225
Replies
13
Views
582
Replies
1
Views
203
Replies
7
Views
466

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,151,837
Messages
5,766,721
Members
425,373
Latest member
ndiejennrrd

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back