Pulling several numbers from a data sheet into another sheet by date/crew/charge type

[autumnm]

I want to fill in a spreadsheet (Sheet A), based on another sheet with data (Sheet B).
However, I need it to look for several items at a time on Sheet B and consolidate the totals before entering into sheet A.


So, on Sheet B, I have a bunch of data - Carrier, Date, Crew, and a breakdown of charges for trucking standby, etc.
On Sheet A, I have a formatted spreadsheet that shows the number of specific charges, based on Date and Crew # (there can be several Carriers on a Crew)

How can I easily enter data into Sheet B and have it populate (and sometimes sum) the number of charges per date & crew afterwards.

Here is Sheet A:
I need a formula/way to look on Sheet B and look at the Charge type (Chainups, etc), the Crew # (Crew 2 in this instance), and the Date and provide the number of chainups from Column E on Sheet B, into the space here on Sheet A for the Date of June 25.
There may also be multiple carriers on Crew 2, so can I have it sum all applicable charges before entering into Sheet A?

[/URL][/IMG]


Here is Sheet B with Data.

[/URL][/IMG]




I am open to reformatting either spreadsheet to make something like this work - just needs to be easily readable for Clients.


A copy of the Document can be found HERE


Thanks!
Autumn