View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default 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