Moving calculations around in Excel

[jschoon4]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]C
[/TD]
[TD]D
[/TD]
[TD]E
[/TD]
[TD]F
[/TD]
[TD]G
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]Company
[/TD]
[TD]Qtr4 March
[/TD]
[TD]Qtr4 April
[/TD]
[TD]Qtr4 May
[/TD]
[TD]Subtotal
[/TD]
[TD]Impact Type
[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]Co. A
[/TD]
[TD]$32,083
[/TD]
[TD]$32,083
[/TD]
[TD]$32,083
[/TD]
[TD]$160,145
[/TD]
[TD]Savings
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]Co. X
[/TD]
[TD][/TD]
[TD]$32,083
[/TD]
[TD]$32,083
[/TD]
[TD]$64,166
[/TD]
[TD]Lost Opportunity
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Total savings
[/TD]
[TD][/TD]
[TD]$224,331
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7
[/TD]
[TD][/TD]
[TD][/TD]
[TD]Lost Opportunity Savings
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

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]

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

A​

[/td][td]

B​

[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][/tr]
[tr][td]

1​

[/td][td]

Company​

[/td][td]

Qtr4 March​

[/td][td]

Qtr4 April​

[/td][td]

Qtr4 May​

[/td][td]

Subtotal​

[/td][td]

Impact Type​

[/td][td][/td][/tr]

[tr][td]

2​

[/td][td]Co. A[/td][td]

$32,083​

[/td][td]

$32,083​

[/td][td]

$32,083​

[/td][td]

$160,145​

[/td][td]Savings[/td][td][/td][/tr]

[tr][td]

3​

[/td][td]Co. X[/td][td][/td][td]

$32,083​

[/td][td]

$32,083​

[/td][td]

$64,166​

[/td][td]Lost Opportunity[/td][td][/td][/tr]

[tr][td]

4​

[/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][td][/td][/tr]

[tr][td]

5​

[/td][td][/td][td][/td][td]Savings[/td][td][/td][td]

$160,145​

[/td][td][/td][td]E5: =SUMIF(F$2:F$3, C5, E$2:E$3)[/td][/tr]

[tr][td]

6​

[/td][td][/td][td][/td][td]Lost Opportunity[/td][td][/td][td]

$64,166​

[/td][td][/td][td][/td][/tr]
[/table]

 

[jschoon4]

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