FOR YOGI and ALADYN - YOUR'E RIGHT.....

[Eddie G.]

Yogi, You are right, this is what I am looking for but the formula that Aladyn provided only counts 5 and the answer should be six as illustrated in the original post:
http://mrexcel.com/board/viewtopic.php?topic=4021&forum=2&5

below is your response. You explained what I am trying to do correctly. I explained it poorly in my original post..... help!!


Eddie,

If I've read this correctly you want the count of any times in either A or B BUT NOT both, so:

A no time and B no time = 0
A time and B no time = 1
A no time and B time = 1
A time and B time ALSO = 1

if this is the case then Aladin's formula is the one to go with.

 

[Eddie G.]

aladin........BINGO....thanks a bunch, it works great, and thanks to all who assisted with my problem