excel data classification summary

EXCEL in the name of the product in accordance with the level at the same time, and their aggregate number, that is a product of the same number of how many, who can help you, hurry!

with countif you assume that A as a product name, B-level products, as, C as for a number of
A number of products is the formula:
= sumproduct ((A1:A100 = “A products”) * (B1:B100 = “a”) * (C1:C100))

assumptions at this time You have a record of 100, according to the actual situation properly …You can change the data was sent to me, I'll help you do this can not tell, can only do so after reading