Count values with different criteria

Good afternoon Gents

I'm working in a file with many data.
The information that i want to work is the following:
column 1 - work orders created by the Technician
column 2 and 3 and 4 - comments A+ B+ C
column 5 - list of comments by type
I need to resume how comments per type were made by the same

Try formula

In the attached are two solutions.
Because I used Power Query with its output going direct to a Pivot table at cell F27, it converted the data in columns A to a proper excel table. This means you can add/change data in that table and all you need to do is refresh the pivot table.
The solution at cell H2 is navic's formula converted to look at Table data. The formulae won't need to change when data is added/removed/extended.
As far as the user's concerned, the pivot table will add new/different comments automatically whereas the formula approach will need those to be added to the list in column F manually. The same apples to the Created by list across the top in row 1.

It's very irritating to put together an answer(s) your question and later find you already had an answer elsewhere. I have wasted my time.
What you've done is called cross-posting, which is all right as long as you provide links to those cross posts. You haven't.

https://www.excelforum.com/excel-fo...240-count-values-with-different-criteria.html
https://www.mrexcel.com/board/threads/count-values-with-different-criteria.1126242/

Manuel Ferreira, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184