Row Column Index Match - Sum amount when data contains a match

[STEFAWN]

[TABLE="width: 618"]
<tbody>[TR]
[TD]Hello,[/TD]
[/TR]
[TR]
[TD]I am trying to find the sum of all charges that contain text "MGT"[/TD]
[/TR]
[TR]
[TD]In Column F3 ($0.66) and F4 ($0.15) are the correct amounts I want the formula to add.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]The formula I am using is =IF(OR(B3=MGT,D3=MGT),SUM(C3,E3)C3+E3)[/TD]
[/TR]
[TR]
[TD]This is totaling both columns but I want it to return the value that contains MGT only.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Thanks

[TABLE="width: 426"]
<tbody>[TR]
[TD]A1[/TD]
[TD]B1[/TD]
[TD]C1[/TD]
[TD]D1[/TD]
[TD]E1[/TD]
[TD]F1[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]ASC 1[/TD]
[TD]ASC 1 $[/TD]
[TD]ASC 2[/TD]
[TD]ASC 2$[/TD]
[TD]Total ASC[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]MGT[/TD]
[TD]$0.66 [/TD]
[TD]405[/TD]
[TD]$0.07 [/TD]
[TD]$0.66 [/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]405[/TD]
[TD]$1.34 [/TD]
[TD]MGT[/TD]
[TD]$0.15 [/TD]
[TD]$0.15 [/TD]
[/TR]
</tbody><colgroup><col span="6"></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[STEFAWN]

The formula worked.
Thank you very much for your responses; I love the turnaround time and the detailed feedback. This site has so many references and information- it's my new favorite place to read!

 

[FlameRetired]

You are welcome. Glad it does the job. Thank you for the feedback and kind words.

This site has so many references and information- it's my new favorite place to read!

Yes. Me too. These forums have become an addiction! LOL