How to count the amount of times it says something in excel 2016 and the quantity column that corresponds to it.

an example of what i mean would be:

SKU NAME | QTY

mcp2401 | 2

mss2301 | 1

mcp2201 | 2

mcp2401 | 3

mcp2201 | 1

I would like to count how many times it says mcp2401 and the qty. In this scenario i would like the answer to be:

SKU NAME | QTY

MCP2401 | 5

MSS2301 | 1

MCP2201 | 3