Formula to find a specific text within a range and return the value in the next cell

I have a huge amount of data and I'm only looking for specific values that correspond with a title.

So in the attachment below you will see two titles listed. "Pricing Special" and "Rounding Overage"

Excel 1.PNG

I want a formula that I can put in the next column (E) that will only pull the value amount to the right of any cell that says "Pricing Special". The issue is that sometimes "Pricing Special" is in one column and sometimes its in another.

Once I have those values in column E I can quickly Sum them to find the total for the Pricing Special vs. having to go through and sort/delete columns/rows every time.

Thanks for your help!

Put this in E2:

=IF(A2="Pricing Special",B2,IF(C2="Pricing Special",D2,""))

then copy down.

Hope this helps.

Pete

Awesome. Thanks guys! This really helps out a lot!