There is a sign of a product (e.g., color), which is located in column 1, the number of items in column 2 and the value of the goods in column 3. I want some cell to output the total value of goods of certain colors (say, blue and green). In General, the sample values from the column 1 to the sum of the values in columns 2 and 3.

asked April 19th 20 at 12:40

1 answer

answered on April 19th 20 at 12:42

It can do a few formulas.

=SUMPRODUCT(--(A2:A13=E2);B2:B13, C2:C13)

https://docs.google.com/spreadsheets/d/1de6iUgnlx0...

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Alexander Ivanov

contributor.pw Google Apps & APIs. Scripts, Tables,...

`SUMPRODUCT`

is one of them=SUMPRODUCT(--(A2:A13=E2);B2:B13, C2:C13)

https://docs.google.com/spreadsheets/d/1de6iUgnlx0...

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Alexander Ivanov

contributor.pw Google Apps & APIs. Scripts, Tables,...

Find more questions by tags Google Sheets

`=SUMPRODUCT(--(A2:A13="Blue");B2:B13, C2:C13)`

. The picture shows that the formula is in cell`F2`

. - Estella_Co commented on April 19th 20 at 12:48