Formula to find the sum of a set of data based on specific criteria

I'm looking for some help to automate a data table I set up in excel. I need the formula to look through a bunch of raw data I have, and add quantities in each row, but only from the rows that have the same machine numbers. I attached the document of raw data I've collected, and on a separate tab, an organized table. I would like this table to automatically be updated with the appropriate data, as I enter it as raw data. I've included details in text boxes in the results tab, that should better explain this. Please let me know if you need any additional explaination, as I realize it was difficult to explain in a simple manner. Thanks in advance.

Originally Posted by micope21

Hi

Please see the file!

Hope this what you looking for!!

Regard
micope21

This is exactly what I'm looking for. Thanks! Just one quick question. How do I change the formula around so that it looks through the whole column for data, rather than a limited number? I know it's set pretty high, but I'm going to be combining large amounts of data on this sheet, so just in case.