Eddie, I tried Aladin's formula and it worked fine for me. Is your data exactly as posted atOn 2002-04-04 14:37, Eddie G. wrote:

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.p...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.p...4021&forum=2&5

## Like this thread? Share it with others