Forum Discussion
How do I define text as a number so that i can formulate a cell to add up?
Hello community, Basically I want to define my "Product" cell as a sum so that in Cell F it can calculate how many different types of products I have. For example, I have Bread and Wine therefore...
Hello,
what you describe is called a distinct count, or a unique count. Here is the Microsoft Support Article about it.
You can also build a Pivot Table with the products in the rows area, then count the resulting rows.
In newer versions of Excel that support the data model, you can add the data to the data model, then build a pivot table, drag the product into Values area and use the Distinct Count to summarize.