detection of cell contents

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
 
Top