If Column X contains specific text in Column Y then SUM Column Z

Scerabi

New Member
Joined
Jan 29, 2015
Messages
9
I'm working with a large table similar to the one below with thousands of Order #'s (Column A). In Column D I'm trying to identify the status of each Order # based upon the Line Description(s) in Column B associated with each unique Order #. If Column B contains "Fiber Facility - Enterprise" then I know the Order is "Pending Facility" and want to identify it as "Pending Facility" in Column D. What's the best way to do this? Thank you! Greatly appreciate the assistance.

If ORD-001938 in Column A, contains "Fiber Facility - Enterprise" in Column B, then enter the text "Pending Facility" in Column D.


ABCDE
Order #Line DescriptionNew MRC
ORD-001938

<tbody>
</tbody>
Dedicated Internet Access (DIA)

<colgroup><col></colgroup><tbody>
</tbody>
0Pending Facility 500
ORD-001938

<tbody>
</tbody>
Fiber Facility - Enterprise

<tbody>
</tbody>
0
ORD-001938

<tbody>
</tbody>
50 Mbps DIA

<tbody>
</tbody>
500

<tbody>
</tbody>
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
1. Lacking in example data, so this may not work, more test data = more accurate solution.

2. Your subject says SUM Column Z.
There is NO column Z in your example data.

To set column D to "Pending Facility" when column B is "Fiber Facility - Enterprise" use

in D2
=IF(LEFT(B2,27)="Fiber Facility - Enterprise","Pending Facility","")
and copy down the column.
 
Upvote 0
Thank you for the info and constructive criticism. Will post a new thread with better explanation and example.
 
Upvote 0

Forum statistics

Threads
1,213,529
Messages
6,114,155
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top