Prev: Finding duplicate addresses
Next: Compare two columns with different codes
From: Jay on 18 Apr 2010 22:57
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.
From: ozgrid.com on 19 Apr 2010 00:42
Try a SUMPRODUCT Function
http://www.ozgrid.com/Excel/sum-if.htm



--
Regards
Dave Hawley
www.ozgrid.com
"Jay" <Jay(a)discussions.microsoft.com> wrote in message
news:F381D1E8-C204-4ECE-8486-01338F39C358(a)microsoft.com...
> 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.

 | 
Pages: 1
Prev: Finding duplicate addresses
Next: Compare two columns with different codes