detection of cell contents

  • Thread starter Thread starter Alain R.
  • Start date Start date
A

Alain R.

Hi,

How can i detect if the contents on my cell is YES (y) or NO (n) with a
simple formula
and add all NO answers...

something like SUMIF(Page1!A:A;"=n";A=A+1)

tia,
Alain
 
Back
Top