The Spreadsheet:
<tbody>
</tbody>
The Problem:
I need to count how many people have at least 1 "x" in a column. The formula should return "3".
If a person has no X in the Sausage, Pepperoni, or Cheese column they are not counted.
Solutions: ?
Name | Sausage | Pepperoni | Cheese |
Joe | x | x | x |
Frank | |||
Ben | x | ||
Kevin | |||
Collin | x | x |
<tbody>
</tbody>
The Problem:
I need to count how many people have at least 1 "x" in a column. The formula should return "3".
If a person has no X in the Sausage, Pepperoni, or Cheese column they are not counted.
Solutions: ?