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
|