Sum of yes answers

[Linda L]

I have a simple table with seven cells that can be answered either Y or N. I
want to sum the total of all Y answers. Can you give me a formula for that?

thanks

 

[Mike H]

Hi,

Try this

=COUNTIF(B1:B6,"y")

Mike

 

[Rick Rothstein]

If you really meant "sum", then look at the SUMIF function; otherwise, if
you actually meant "count", then look at the COUNTIF function. If you had
provided more details about your layout, I would have been able to give you
suggested formula to try.