Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Did you try

=COUNTIFS(Catalog.E4:E6000,"x",Catalog.G4:G6000,"x",Catalog.M4:M6000,"x",Catalog.M4:M6000,"D"",Catalog.M4:M6000,"T").

You could possibly also use a regular expression.

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.