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