# Formula to multiply a single value by an array then sum

#### Tyny8

##### New Member
Hello all,

Your help is much appreciated. I am looking for an excel formula that will allow me to perform the following logic:
if a cell value in (M3:BA3)="D" then multiply C29 by the corresponding value in (M29:BA29), then sum all of the products. Please let me know if further explanation is required, thank you!

### Excel Facts

Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Array-Enter the following:
=SUM(IF(M3:BA3="D",M29:BA29 * \$C\$29))
Array entering is entering the formula with Ctrl+Shift+Enter (not just Enter)

Thank you, problem solved.

Replies
2
Views
206
Replies
2
Views
150
Replies
4
Views
237
Replies
3
Views
256
Replies
5
Views
77

1,219,812
Messages
6,150,367
Members
450,955
Latest member
rose8693

### 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