Moving calculations around in Excel

[jschoon4]

											A B C D E F G 1 Company Qtr4 March Qtr4 April Qtr4 May Subtotal Impact Type 2 Co. A $32,083 $32,083 $32,083 $160,145 Savings 3 Co. X $32,083 $32,083 $64,166 Lost Opportunity 4 5 Total savings $224,331 6 7 Lost Opportunity Savings <tbody> </tbody>

<tbody>
</tbody>

I want all Values in Column F that has an "Impact Type of Lost Opprotunity" Not to get calculated in Cell F5, But I want that data instead added in Cell F7

 

[shg]

So in your example, ...

 

[jschoon4]

Yes? I want to keep all savings in Column F, But I don't not want to collect Cell Vaules in Column F who have a Impact type in Column G of "Lost opportunity"

 

[shg]

Row\Col	A​	B​	C​	D​	E​	F​	G​
1​	Company​	Qtr4 March​	Qtr4 April​	Qtr4 May​	Subtotal​	Impact Type​
2​	Co. A	$32,083​	$32,083​	$32,083​	$160,145​	Savings
3​	Co. X		$32,083​	$32,083​	$64,166​	Lost Opportunity
4​
5​			Savings		$160,145​		E5: =SUMIF(F$2:F$3, C5, E$2:E$3)
6​			Lost Opportunity		$64,166​

 

[jschoon4]

Shg, Brilliant, it worked! Thanks a lot. Awesome job!