In the following example i have the dept in one coloumn and y/n criteria in other, is there any formula for me to get the total count of Y in the summary against each dept

Pls assist

dept Y/N
sales Y
it Y
production N
quality N
sales N
it Y
production Y
quality Y
it Y

Summary
sales
it
prod