Sum of yes answers

L

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
 
R

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.
 
Top