This is my spread sheet.

-- A -- B -- C -- D -- E
1 H1500 2 X1500 2
2 T448601 1 N0421 1
3 H1500 2 T448601 1
4 M1224 1 S789003 1

What I need is:

Cell Column “E” should return values as follows:

If “A1” = “x1500”, return value of B1. (ie, wherever “A” = x1500, E will show the same as B. If that condition is not met, E will show a value of zero.)

However…it is not just “x1500” I am looking for, I have 11 different codes I need it to search.

In plain English:

If “A” equals either “x1500” or “x1001” or “x2525” etc etc, then E should show the value of B.

Heres the real scenario, might make it a bit easier…”X1500” represnts one of our products…I need to count how many of those products appear, but I need to count all 11 “X” products. I can easily create a formula that counts how many times an “x” code appears, but it doesn’t take into account the column next to it (quantity).

To throw another perm in…I need this formula to search not just A1, but C1, E1 etc so I have 6 different columns searched for any “x” codes!!