Try a SUMPRODUCT Function
http://www.ozgrid.com/Excel/sum-if.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Jay" wrote in message
...
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.