Count the number of cells that contain text in the number

Column A contains numbers. There are a few cells in Column A that have a "x" place in front of the number. Column B shows whether this item is open or closed. I need a formula that will count the number of cells in column A that contain the letter x.

I would then be able to create a pivot table that would show me the number of x'd items that are open and the number that are closed.

Example:
1098165-02 closed
x100629-01 open
x100629-02 closed
100104-01 closed

I need to show that there are two in the above list that contain the letter x. One is open, One is closed.

Thanks so much for you help.

Given the Pivot requirement it would make sense to store a 1/0 flag adjacent to each transaction denoting the presence of "x" in the string, eg:

C1: "X-Type"
C2: =0+(LEFT(A2)="x")
copied down

You can then generate both Pivot and count of x quite simply (use the X-Type field as Page Field in your Pivot set to 1)

(for a single cell calc of "x" you can use COUNTIF(range,"x*") but given you have the 1/0 flag there's little need)