How to write the formula for the sample values from column 1 calculate the sum of values from columns 2 and 3?

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.
April 19th 20 at 12:40
1 answer
April 19th 20 at 12:42
It can do a few formulas. SUMPRODUCT is one of them

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

5e9b5dc6288fd038068141.png

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

━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Alexander Ivanov
contributor.pw Google Apps & APIs. Scripts, Tables,...
Alexander, thank you for Your response. But I need something a little different. More precisely, I don't really have correctly identified the problem. I need to do it all in one step (one formula). That is, there is about the same as You depicted, the table, and one cell that should receive the calculated result. And the signs of selection must be entered directly in a formula, they are actually permanent. A table with the time updated, may also change the values in the column Basis, and, accordingly, changing the result in the cell. - alyson_Bahringer commented on April 19th 20 at 12:45
@alyson_Bahringer, not scoff. Give an example. Add "Blue" to be =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

Find more questions by tags Google Sheets