COUNT with OR

[tony0682]

This seems like a very simple problem, but I have no idea how to go about it.

I have 2 columns that have x or blank, or both x and both blank. I want to sum the range if either have an X but not double count if both have an X.

A B
1X
2 X
3X X
4X
5

The total for the above should be 4

 

[tony0682]

Awesome. Thanks Valko!

 

[T. Valko]

Awesome. Thanks Valko!

You're welcome!

 

[mikerickson]

Ah. Works like a charm. Can you explain why using LEFT() yields the correct answer while without it doesn't?

Without LEFT, it will miss "XX".