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

Hi,

Try this

=COUNTIF(B1:B6,"y")

Mike

"Linda L" wrote:

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

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.

--
Rick (MVP - Excel)


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