SUMIF?

[BAS]

Not sure what function to use to do a sum of Y's or N's.

Example: (Starting in cell C5 and going down to C8)

Y
N
N
Y

In cell C9, what function do I use to sum the Y's that are found in C5:C8?
So that the answer is 2.

Thanks for the help

 

[Eduardo]

Hi,

=COUNTIF(C5:C8,"Y")

 

[RagDyeR]

=Countif(C5:C8,"Y")
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

Not sure what function to use to do a sum of Y's or N's.

Example: (Starting in cell C5 and going down to C8)

Y
N
N
Y

In cell C9, what function do I use to sum the Y's that are found in C5:C8?
So that the answer is 2.

Thanks for the help