Hello,

I have spreadsheet that shows the number of parts purchased by each customer
- customer, PN, qty purchased. There is a second spreadsheet that shows the
maximum order quantity for each item these customers can purchase. I want to
know which stores went over the maximum order quantity for each item. The
information is set up with all the customers in the first column, part
numbers on the first row and the quantity purchased for each store below the
part number. How do I compare and extract the information I need?


Thank you,

Something like

=SUMIF(Sheet1!1:1,"Customer",Sheet1!3:3)

perhaps

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Richard" wrote in message
...
Hello,

I have spreadsheet that shows the number of parts purchased by each
customer
- customer, PN, qty purchased. There is a second spreadsheet that shows
the
maximum order quantity for each item these customers can purchase. I want
to
know which stores went over the maximum order quantity for each item. The
information is set up with all the customers in the first column, part
numbers on the first row and the quantity purchased for each store below
the
part number. How do I compare and extract the information I need?


Thank you,