SUMIF?
 

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

SUMIF?
 

Hi,

=COUNTIF(C5:C8,"Y")

"BAS" wrote:

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

SUMIF?
 

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

HTH,

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

"BAS" wrote in message
...
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