Summing and multiplying for multiple criteria

E

Ed

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
 
T

Toppers

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top