Double and a Triple Cross Reference Data Dumps

So I am trying to create a spreadsheet for work that helps with Our Inventory Management System

But the Data Dump that the System gives is a Mess to say the least and I need to figure out how to Cross Reference Product, Person and Today's date to get Today's Product only and then subtract that number with Person and Product in order to get the Hold Over.

Sorry, I'm not familiar with inventory management systems, so the term "hold over" doesn't mean much to me. However, this put in a cell will give you the sum of all oranges grown by Sally with today's date:

Formula:

Please Login or Register  to view this content.

Omit the final (sheet1!$M$2...) to get all oranges grown by Sally in the data table:

Formula:

Please Login or Register  to view this content.

Does this help you get started?

Tim

Haha! Must've just hit it lucky!

I see you're relatively new to the forum, so just a gentle reminder to mark the thread as [SOLVED] using the thread tools at the top of the page. You can also leave feedback and show your appreciation for anyone who's helped by hitting the * button to the left of each post.

Tim