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
Recent Comments