If Match then SUM? - Wanting to add multiple values if criteria matches

Column A would be Recipe Numbers, Column B the Planned Total.

I want to search column A for all matching recipe numbers.
Then, any recipes that match, look in column B for the planned totals, adding all incidents where they match.

Then the most difficult part, which just occured to me now... I only need the Total Planned Total and Recipe name reported once...

Recipe#..........Planned Total
450................100
600................75
620................125
450................50
620................180
450................100
600................200
450................110

I will not be able to sort these lists.

If-Match-Sum? to display:
Recipe#............Total Planned Total
450....................360
600....................275
620....................305


I've researched for the first part... and it seems like Match will only find the first match and not look further? Am I wrong on this?
How to display the results hadn't even occured to me yet, since I was still trying to figure out how to GET the result.

Thank you!

There are approximately 900 Recipe numbers. On any given day, about 30 random numbers will be used.

Actually, they won't be random. It's a planned menu....

Thinking, please wait....

Okay... Column A will be referenced from the worksheet where the information is entered. So the information won't be totally random, but it will change on a daily basis. There is a full recipe index on another worksheet.

Bah... I'm not sure if I'm even coherent.

I'll do that shortly... The rest of the workbook was only theory and chicken scratch on paper. I was trying to get a good outline going before I dove into the whole project.
I'm building it all now.

This SUMIF did work... spawned a secondary question once I got all of it together, but that is for another thread I think.
It was the too many recipe numbers that had me confused. The X1 part of the formula, referring back to the number in column A of the same row... that was the "KEY" I was missing.

Please Login or Register  to view this content.

Thank you for your help!