Summarize data in Excel without VBA or PivotTable

1

Sorry if this question has already been answered, but I'm not even getting the question to do the proper search.

I have a list of products sold in excel, and I need to select the top three products on the list. Until then, you could use the "Major" function. The problem is that the products can be repeated in the list, I do not have room to create PivotTables, or use VBA in the worksheet.

Here is an example of the data:

    Produto | Vendido | QTT
    P1      |  1073,79|   21
    P2      |   553,72|   25
    P3      |   748,94|    6
    P4      |  1017,97|   13
    P1      |    98,98|    4
    P2      |   173,71|    9
    P3      |   189,98|    2
    P5      |   250,97|    3

I needed to put the products P1, P4, and P3 in a column on the same worksheet, with their values.

Is this possible?

    
asked by anonymous 09.05.2017 / 17:37

1 answer

1

Use somases to add up all values sold for a particular product.

=SOMASES(B2:B9;A2:A9;"P1")

Where the interval B2:B9 are the values that must be summed, the interval A2:A9 the comparison interval (products) and the last parameter what should be compared P1 (PRODUCT 1).

    

09.05.2017 / 20:24