Sum of yes answers

  • Thread starter Thread starter Linda L
  • Start date Start date
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
 
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.
 
Back
Top