COUNTIF, only counting once if both cells contain the data
Hi David
You are right, I just couldn't make i work without at first attemt.
Don't know why :-(
Regards,
Per
On 2 Dec., 21:53, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Do you need the double unary minus operators, Per? *Doesn't the plus
operation coerce the conversion from boolean to number?
Wouldn't =(OR(C6="Y",D6="Y"))+(OR(F6="Y",G6="Y")) do the job?
--
David Biddulph
|