Formula to multiply a single value by an array then sum

[Tyny8]

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!

 

[p45cal]

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)

 

[Tyny8]

Thank you, problem solved.