Conditional sumproduct? I think????

Hello ,


I need to add a new total at the bottom of the sheet, so we have the following columns

Reuse/ New Previous Project SMPs Remaining Catalogue item Unit Quantity Unit Price Total per SMP 48 Month Shortfall Charges

I need to create a total from Total per SMP (Column I) multiplied by SMPs remaining (Column D), from rows 27-33, but only want it to sum the ones in which Column B (Reuse/New) has a value of R

You mean?

=Sumproduct(--(B27:B33="R"),I27:I33,D27:D33)