Hi, I need to to produce a total of items with two categories. I have to count the number of times a text occurs in a column and on another column its category. The third column would be the quantity that I have to multiply with the result.

Example:

Animal: Dog
Type: German Shephered
Qty: 5

I have tried countifs but I cannot work it out to multiply with the quantity.