Hi,

=sumif(RngInvoices, InvoiceNo, RngBoxesSold)

Where RngInvoices is the range containing your invoice numbers
InvoiceNo is the Invoice # selected
RngBoxesSold is the range contain the boxes sold

e.g. =Sumif($a$2:$a$1000,InvoicNo,$D$2:$d$1000)

HTH

"Jennifer" wrote:

Can I just say I am truelly learning Excel is never ending! This project
started rather modest. Ha!

Ok- I have a userform it displays an invoice # via cbobox. How do I have a
label on the form that looks at that invoice # goes to the producedata
worksheeet and does a sumif of the boxes sold. Thank you!
--
Though daily learning, I LOVE EXCEL!
Jennifer