JimS
07-28-2010, 01:52 PM
I have a worksheet that contains information about orders where Column A is the Order Number, Column B is the Part Name and Column C is the Cost of the part.
Individual orders can have several line items (rows) but have the same order number in Column A.
If an individual order’s total is >$250,000 then I need it to be included in the Sum of all the orders that are >$250,000.
The formula should be a Sum of all the orders only if the individual order’s total is >$250,000.
Thanks for any help...
JimS
Individual orders can have several line items (rows) but have the same order number in Column A.
If an individual order’s total is >$250,000 then I need it to be included in the Sum of all the orders that are >$250,000.
The formula should be a Sum of all the orders only if the individual order’s total is >$250,000.
Thanks for any help...
JimS