Count Number of Items With A and B

I have a workbook (attached).

I want to count the number of times North AND Win, North AND Lose etc.

Can anyone provide me a way of doing this. I dont want to have to use B2&C2 for example. I know I could do this and then use an IF statement (I think).

Thanks in advance
dvent

Using your posted workbook...

If you're certain the source data contains no extra spaces:

Please Login or Register  to view this content.

Otherwise, try this:

Please Login or Register  to view this content.

copy either formula down as far as you need.

Does that help?