Stuck on sum

[Bal_Ocado]

[TABLE="width: 500"]
<tbody>[TR]
[TD]column A
[/TD]
[TD]column B
[/TD]
[TD]column C
[/TD]
[TD]columnD
[/TD]
[TD]column E
[/TD]
[/TR]
[TR]
[TD]P
[/TD]
[TD][/TD]
[TD]5156
[/TD]
[TD]15%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD]6555
[/TD]
[TD].05%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Y
[/TD]
[TD][/TD]
[TD]6265
[/TD]
[TD]10%
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]P
[/TD]
[TD][/TD]
[TD]1165
[/TD]
[TD]5.5%
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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