I need to sum a column that meets two criteria definitions - such as two
different customers (the condition data is in the same column).

I also need to multiply two fields together based upon the same criteria -
to include the two customers that meet the criteria in my product sum. Again
the customer info is in the same column.

Such as multiplying price * qty for customer #'s 100 and 200. Also, summing
qty for customer #'s 100 and 200.

Customer Price Qty
100 1.50 10
200 3.00 50
100 5.00 5
300 1.25 100
100 6.00 75
200 3.30 15
400 4.50 10
300 2.25 60

With data in columns A to C:

=SUMPRODUCT(--($A$2:$A$9={100,200})*($B$2:$B$9)*($C$2:$C$9))

=SUMPRODUCT(--($A$2:$A$9={100,200})*($C$2:$C$9))

"Ed" wrote:

I need to sum a column that meets two criteria definitions - such as two
different customers (the condition data is in the same column).

I also need to multiply two fields together based upon the same criteria -
to include the two customers that meet the criteria in my product sum. Again
the customer info is in the same column.

Such as multiplying price * qty for customer #'s 100 and 200. Also, summing
qty for customer #'s 100 and 200.

Customer Price Qty
100 1.50 10
200 3.00 50
100 5.00 5
300 1.25 100
100 6.00 75
200 3.30 15
400 4.50 10
300 2.25 60