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

[STEFAWN]

Hello,

I am trying to find the sum of all charges that contain text "MGT"

In Column F3 ($0.66) and F4 ($0.15) are the correct amounts I want the formula to add.

The formula I am using is =IF(OR(B3=MGT,D3=MGT),SUM(C3,E3)C3+E3)

This is totaling both columns but I want it to return the value that contains MGT only.

Thanks A1 B1 C1 D1 E1 F1 A2 ASC 1 ASC 1 $ ASC 2 ASC 2$ Total ASC A3 MGT $0.66 405 $0.07 $0.66 A4 405 $1.34 MGT $0.15 $0.15 <tbody> </tbody><colgroup><col span="6"></colgroup>

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

 

[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