countif or sumproduct with 2 part formula.

Just for completeness an "OR" condition uses "+".

Both work on the principle that TRUE=1, FALSE=0 so If A AND B are TRUE then we multiply (So YES it is multiply!) 1 * 1 = 1 . If either are FALSE then we have 1*0 or 0*1 =0.

For an "OR" condition we add so A OR B are TRUE we will add 1+0 or 0+1 =1: if neither are TRUE we get 0+0=0

All clear now!

Originally Posted by JohnTopley

Just for completeness an "OR" condition uses "+".

Both work on the principle that TRUE=1, FALSE=0 so If A AND B are TRUE then we multiply (So YES it is multiply!) 1 * 1 = 1 . If either are FALSE then we have 1*0 or 0*1 =0.

For an "OR" condition we add so A OR B are TRUE we will add 1+0 or 0+1 =1: if neither are TRUE we get 0+0=0

All clear now!

Much better, I love excel, but learn something new all the time.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Originally Posted by JohnTopley

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Running through some data to double check, will do in about 2 min