Count DISTINCT in ColumnA IF ColumnE status='QA'

[jaymz69]

Count DISTINCT in ColumnA IF ColumnE status='QA'

I want to have a new column (RESULTS) where the formula counts only ColumnA (DISTICNLY) IF ColumnE cell = 'QA'



Small example:

Category	Status	RESULTS
blue	QA	3​	<=== ONLY 3 DISTINCT Catgories that have status='QA'
blue	QA
blue	no
gray	no
gray	no
orange	QA
orange	no
pink	QA
pink	no
pink	no
pink	no
pink	QA
purple	no
red	no
red	no
red	no
yellow	no

 

[jaymz69]

In future when posting questions for apps other than Excel, please post them in the General Discussion & Other Applications section of the board & clearly state what you are using.
Thanks

OK, every time I look online I can never find anything on the QUIP, but Excel has many articles and most work on QUIP, that was my meaning on why. Otherwise may get nothing or more confusing from what I have experienced else where.



Thank you