need help with formula

J

Jay

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pallets w/varying sizes & weights need to fit in restricted space 7
Running total with IF statements 2
Summing a non continuous range 7
Help with Array Formula 5
Specify columns to add for months MTD Diff 3
Specify MTD Diff by month's columns 0
specify which month's columns to use in mtd calculation 0
I need to subtract5 pallets allready inserted. 3

Top