if functions

[Guest]

I have the following problem:
In sheet 1 I have :
Column A > party codes (Customers)
Coloumn B > Bill number
Coloumn C > Bill dates
Coloumn D > Material code (i.e. different materials sold against the
mentioned bill)
Coloumn E > Quantity of materials ( i.e. number of cartons sold of a
material against a mentioned bill)
The same material a party can buy many times against a specific bill.
I need to summarise the data in another sheet (sheet 2) in which :
Coloumn A > Will be the material code
Coloumn B > Will be the quantity of material sold against each code to each
party.
Row 1 > will be the customer codes across coloumns, thus coloumn B will one
customer, coloumn c will be another customer and so on.
That is I want to summarise the data a total quantity of " Z " of material "
X " bought by a party " Y "
Kindly help, I have been pursuing this for long but unable to come out with
a fool proof formula

 

[Paul Sheppard]

I have the following problem:
In sheet 1 I have :
Column A > party codes (Customers)
Coloumn B > Bill number
Coloumn C > Bill dates
Coloumn D > Material code (i.e. different materials sold against the
mentioned bill)
Coloumn E > Quantity of materials ( i.e. number of cartons sold of a
material against a mentioned bill)
The same material a party can buy many times against a specific bill.
I need to summarise the data in another sheet (sheet 2) in which :
Coloumn A > Will be the material code
Coloumn B > Will be the quantity of material sold against each code t
each
party.
Row 1 > will be the customer codes across coloumns, thus coloumn B wil
one
customer, coloumn c will be another customer and so on.
That is I want to summarise the data a total quantity of " Z " o
material "
X " bought by a party " Y "
Kindly help, I have been pursuing this for long but unable to come ou
with
a fool proof formula

Hi Harsh

Try Using a Pivot Table

Data > Pivot Table

Hope this helps

Pau

 

[Guest]

Thanks Paul. I had tried using the Pivot table but it did'nt help