Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
complex criteria summing | Excel Discussion (Misc queries) | |||
Need Help: Summing Multiple Criteria | Excel Worksheet Functions | |||
Summing Fields with Multiple Criteria | Excel Discussion (Misc queries) | |||
Summing Rows with Multiple Criteria | Excel Worksheet Functions | |||
Summing with multiple criteria | Excel Worksheet Functions |