Multiplying with Criteria

[torkunc]

Hey,

In Col. A, I have ID numbers and in Col.B I have figures. I want to multiply Col. B if my criteria fits in Col. A.

[TABLE="class: grid, width: 250, align: left"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]2,00[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2,50[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]1,80[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]2,5[/TD]
[/TR]
</tbody>[/TABLE]









So the result should be :

Criteria : 2
Result : 2,50*1,80*2,5 = 11,25

Thnx a lot guys.

 

[wideboydixon]

Book1
	A	B	C	D	E
1	1	2		Criteria	2
2	2	2.5		Result	11.25
3	2	1.8
4	2	2.5
Sheet1

Cell Formulas
Range	Formula
E2	{=PRODUCT(IF($A$1:$A$4=$E$1,$B$1:$B$4,1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

WBD

 

[torkunc]

Thx a lot.
I was trying to do it with SUMPRODUCT...