Hi all,

I am in a tricky situation. i have a table which basically includes 6 Columns.

Date, Location,Location 2, No. of pieces, Weight, Pallet/Container.

Then i have another table on sheet 2 with 9 columns,

Location, Location 2, Container Dec., Container Jan., Container Feb., Pallet
Dec.. Pallet Jan., Pallet Feb. and Total weight in 3 months.

Now i need 2 formulas. one shoud basically say something like:
1- Between Dec.01.2009 and Dec.31.2010, With Location A and Location B, Sum
up all Pallets and sum up all containers in this cell.

I dont know if that is understandable, but i really need this to be done.