Solved: Order Form

[Alasbabylon]

I am trying (with no success so far) to figure out how to do a search and add function. I have a worksheet with over 600 line entries on one sheet and approximately 56 entries on the second worksheet. I want to search the first sheet for every instance of. I want to search sheet 1 for every instance of each entry on sheet 2, add the number in the corresponding QTY column on Sheet 1, and get a total of how many pieces of each item are being ordered. How do I do this?
Alasbabylon - truly befuddled once again.

[lucas]

I'm not very good at this but it looks like you need a sumif formula. See attached.

Edit: I told you I wasn't very good....had to change the formula's in cells G3:G17

I also notice that you had spelled Peanuts, RS one way in one column and differently in the other set so it didn't find it...they will have to be spelled the same...same spaces etc.

[Alasbabylon]

Fantastic! You are AWESOME! Thanks so much. I popped it in there and it was like magic.
Alasbabylon

[lucas]

Your welcome, Glad it helped.