Desperately need help with a countif formula/ cells staying blank

[Jason M]

Greetings form a newbie

Need help with this in Excel 2010 (please, please, please)

=IF(COUNTIF(C6:C8,"N"),"N","Y")

Cell C9 will return a N value if N is selected anywhere between C6 and C8.

The problem is C9 returns a Y value if C6 to C8 are all blank.

Ideally I want C9 to remain blank if there has been no input

Might be simple but I've been racking my brain for a few days over it

Cheers

Jason

 

[Trebor76]

Hi Jason,

Welcome to MrExcel!!

This formula should do the trick (there's other ways of doing it as well I'm sure):

=IF(COUNTIF($C$6:$C$8,"")=3,"",IF(COUNTIF($C$6:$C$8,"N")>=1,"N","Y"))

Regards,

Robert

 

[Peter_SSs]

Welcome to MrExcel!

For one of those variations suggested by Robert ..
=IF(COUNTIF($C$6:$C$8,"N"),"N",IF(COUNTA($C$6:$C$8),"Y",""))

 

[Jason M]

Gentlemen,

I thank you both so very much, both solutions worked.

Now I've got the learning of working out the moving bits and pieces of the formula for "next time"

Cheers,

Jason