Counting cells with a criteria based on content and adjacent cell

Hi

I have a list of names, lets say Tony in A1:A3 and then Kay in A4:A6 and John in A7:A9.

In the B column some of the nmaes have an X next to the name. How can I count how many cells are there in column A with the name Tony in with an X net to it?

I can add a column and then add the 2 test strings together then count the TonyX's but I dont want to display the column. I hide the column but its part of an outline so when the group expands it shows up again. If I try to make it zero width it still shows up after group expansion.

Is there a dbase function I can do this with in a single cell.

In the end I had to move the third column to the other side of the sheet and now its a pin to audit

Cheers

That did the trick!

Thanks. It also help me find other things

Cheers