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.

A	B
1	2,00
2	2,50
2	1,80
2	2,5

<tbody>
</tbody>

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...