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.
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.