Forum Discussion
Solved
Look up Name and count how many are X or Y
I have a table with Carriers and another column with Trailer Code (either shipping or receiving). What would be a good formula for counting how many shipping trailers there would be for a spec...
CaitlynEXCEL The attached workbook contains four examples of possible answers to your question. If your Excel version supports dynamic array functions, you could use FILTER. Otherwise COUNTIFS or SUMPRODUCT. Or, why not use a Pivot Table?
What is your Excel version? Do you have Microsoft-365?