Excel: Count Unique Values on Multiple Criteria

I am looking to count unique values in my sheet based on three criteria. Column B contains a list of product types (text) Column D contains a list of formulas (text) Column E contains a list of units made (#) I want to count the unique values in column D when units made (column E) are greater than 0 and the product type (column B) is equal to cell A2. Thanks

This question generated 11 answers. To proceed to the answers, click here.

This thread is current as of April 24, 2017.

For more resources for Microsoft Excel