Need formula to total products in a dynamic range based on company name

Afternoon,

I need to figure out how to get a total number of a given product for each company in a large list of products by company.

I've tried with offset, but I don't know how to define the range to just one company.

I've attached an excel file that shows what I mean.

Thanks in advance for your help!

Blake

A Pivot Table is a good idea. Also, you could enter this in C2 and copy it down:

=IF(A2=A3,"",COUNTIFS(A:A,A2,B:B,"Product ABC"))

Thank you all for your suggestions!

A pivot table would be nice, but I need a way to compare the data and I'm not sure how to do that with pivot tables.

Per my example, I need to know how much "Product ABC" a company bought, and how much product "5" and then get a ratio for "Product ABC"/"5"

Is there a way to do that with pivot tables?

Thanks