If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
need help with formula
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. |
#2
|
|||
|
|||
need help with formula
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. |
Thread Tools | |
Display Modes | |
|
|