I would love to but I haven't created the files yet simply because it will be quite time-consuming to do so and, since I don't know if or how it can be done, I didn't want to waste my time (or yours for that matter). Suffice to say, column A:D (for example) is populated by the name and style of the item. Let's say column E is the quantity sold. So it could read: Shirt, Men's, casual, black, 6. The next item would read: Shirt, Men's, formal, black, 12. This is clearly an oversimplification of the actual files, but I can adjust it if I have the bare bones idea. There would literally be hundreds of rows of information. I would like, on Sheet 2, to look for every instance of Shirt, Men's, casual, black and add the values in column E.