Stuck on sum

[Bal_Ocado]

column A	column B	column C	columnD	column E
P		5156	15%
Y		6555	.05%
Y		6265	10%
P		1165	5.5%

<tbody>
</tbody>

Hi Guys,

I have something similar to the data above.

I need to, in one cell, sum up the multiple of columns C and D, if column A shows 'P'. How can I do this in one cell? Essentially a sumif, if the sum range could be CxD. I can't use another column to multiply and get a sum range as it doesn't work in my file, so it must be done in the formula.

Thanks

 

[Special-K99]

=sumproduct((a1:a4="p")*(c1:c4)*(d1:d4))

 

[Bal_Ocado]

Brilliant! Thanks