SUMIF - - but I need more ...

[dcavaiani]

Calc	Type	ExpRatio	Holding%	FundCost	Mixed
$36,233	equity	0.69%	9.35%	$250
$29,026	mixed	0.60%	7.49%	$174	0.38
$41,933	fixed	0.97%	10.82%	$407
$32,045	equity	0.77%	8.27%	$247
$9,934	mixed	0.63%	2.56%	$63	0.51
$8,761	equity	1.31%	2.26%	$115
$7,429	mixed	1.04%	1.92%	$77	0.29
$42,075	equity	0.90%	10.86%	$379
$19,146	equity	1.13%	4.94%	$216
$22,023	equity	0.96%	5.68%	$211
$14,574	fixed	0.93%	3.76%	$136
$28,024	equity	0.62%	7.23%	$174
$24,800	mixed	0.56%	6.40%	$139	0.24
$12,119	fixed	0.62%	3.13%	$75
$36,001	equity	0.75%	9.29%	$270
$9,527	equity	1.07%	2.46%	$102
$0	fixed	0.99%	0.00%	$0
$13,764	equity	1.38%	3.55%	$190

<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Given the above data, I want to ADD UP (and place in a new cell): IF "Type" = "mixed", Then I want to multiply the ratio in the "mixed" column Times the amount in the Calc column.

 

[gaz_chops]

Try

=SUMPRODUCT(($B$3:$B$21="mixed")*($A$3:$A$21)*($F$3:$F$21))

 

[AlanY]

is that what you're after?

Book1
	A	B	C	D	E	F	G
1	Calc	Type	ExpRatio	Holding%	FundCost	Mixed
2	$36,233	equity	0.69%	9.35%	250		$24,203
3	$29,026	mixed	0.60%	7.49%	174	0.38
4	$41,933	fixed	0.97%	10.82%	407
5	$32,045	equity	0.77%	8.27%	247
6	$9,934	mixed	0.63%	2.56%	63	0.51
7	$8,761	equity	1.31%	2.26%	115
8	$7,429	mixed	1.04%	1.92%	77	0.29
9	$42,075	equity	0.90%	10.86%	379
10	$19,146	equity	1.13%	4.94%	216
11	$22,023	equity	0.96%	5.68%	211
12	$14,574	fixed	0.93%	3.76%	136
13	$28,024	equity	0.62%	7.23%	174
14	$24,800	mixed	0.56%	6.40%	139	0.24
15	$12,119	fixed	0.62%	3.13%	75
16	$36,001	equity	0.75%	9.29%	270
17	$9,527	equity	1.07%	2.46%	102
18	$0	fixed	0.99%	0.00%	0
19	$13,764	equity	1.38%	3.55%	190
Sheet1

Cell Formulas
Range	Formula
G2	=SUMPRODUCT(A2:A19,F2:F19)

 

[dcavaiani]

Try

=SUMPRODUCT(($B$3:$B$21="mixed")*($A$3:$A$21)*($F$3:$F$21))

Awesome, thank you !

 

[dcavaiani]

is that what you're after?

	A	B	C	D	E	F	G
1	Calc	Type	ExpRatio	Holding%	FundCost	Mixed
2	$36,233	equity	0.69%	9.35%	250		$24,203
3	$29,026	mixed	0.60%	7.49%	174	0.38
4	$41,933	fixed	0.97%	10.82%	407
5	$32,045	equity	0.77%	8.27%	247
6	$9,934	mixed	0.63%	2.56%	63	0.51
7	$8,761	equity	1.31%	2.26%	115
8	$7,429	mixed	1.04%	1.92%	77	0.29
9	$42,075	equity	0.90%	10.86%	379
10	$19,146	equity	1.13%	4.94%	216
11	$22,023	equity	0.96%	5.68%	211
12	$14,574	fixed	0.93%	3.76%	136
13	$28,024	equity	0.62%	7.23%	174
14	$24,800	mixed	0.56%	6.40%	139	0.24
15	$12,119	fixed	0.62%	3.13%	75
16	$36,001	equity	0.75%	9.29%	270
17	$9,527	equity	1.07%	2.46%	102
18	$0	fixed	0.99%	0.00%	0
19	$13,764	equity	1.38%	3.55%	190

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula G2 =SUMPRODUCT(A2:A19,F2:F19) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Awesome - you have actually simplified it too. Sometimes we just think too hard