Search code examples
excelgoogle-sheetsexcel-formulasumifs

Google sheets - Sum of values in excel with condition

Considering this scenario with an example I require

Excel function that provides a solution for the following problem

Column A and B have the following entries. D has the unique values of column A

    A    B    C    D    E
1   x   10         x    25
2   y   20         y    30
3   x   15
4   y   10

So the Output will be displayed on the Columns E with the sum of the corresponding values in column B

Solution

  • try this in or 

    =sumifs(b:b, a:a, d1)