To Calculate the qty b/w two dates
 

In Sheet 1 the table is as below
SL.NO Received Dia Qty (MT)
1 29-Mar-03 20 19.89
2 31-Mar-08 10 6.51
3 31-Mar-08 10 0.63
4 11-Apr-08 10 1.43
5 27-Apr-08 20 8.23
6 28-Apr-08 20 25
7 3-May-08 16 9.77
8 3-May-08 20 10

In sheet 2 the table is as below
Starting Date Closing Date 8 10 12 16 20 25 32
1-Jun-08 30-Jun-08
1-Jul-08 31-Jul-09
1-Aug-08 31-Aug-08
I need the qty recieved b/w two dates based on the Dia Of Bar

To Calculate the qty b/w two dates
 

Sorry the Starting day and closing date is MArch and April

"vmohan1978" wrote:

In Sheet 1 the table is as below
SL.NO Received Dia Qty (MT)
1 29-Mar-03 20 19.89
2 31-Mar-08 10 6.51
3 31-Mar-08 10 0.63
4 11-Apr-08 10 1.43
5 27-Apr-08 20 8.23
6 28-Apr-08 20 25
7 3-May-08 16 9.77
8 3-May-08 20 10

In sheet 2 the table is as below
Starting Date Closing Date 8 10 12 16 20 25 32
1-Jun-08 30-Jun-08
1-Jul-08 31-Jul-09
1-Aug-08 31-Aug-08
I need the qty recieved b/w two dates based on the Dia Of Bar

To Calculate the qty b/w two dates
 

Suppose Sheet1 Col B has got the dates try the below formula to get the total
qty for Dia 10..Once you try out this in Sheet1 you can change 10 to a
reference... Please try and feedback

=SUMPRODUCT(--(B1:B100=DATE(2009,4,1)),--(B1:B100<=DATE(2010,3,31)),--(C1:C100=10),D1:D100)
--
If this post helps click Yes
---------------
Jacob Skaria


"vmohan1978" wrote:

Sorry the Starting day and closing date is MArch and April

"vmohan1978" wrote:

In Sheet 1 the table is as below
SL.NO Received Dia Qty (MT)
1 29-Mar-03 20 19.89
2 31-Mar-08 10 6.51
3 31-Mar-08 10 0.63
4 11-Apr-08 10 1.43
5 27-Apr-08 20 8.23
6 28-Apr-08 20 25
7 3-May-08 16 9.77
8 3-May-08 20 10

In sheet 2 the table is as below
Starting Date Closing Date 8 10 12 16 20 25 32
1-Jun-08 30-Jun-08
1-Jul-08 31-Jul-09
1-Aug-08 31-Aug-08
I need the qty recieved b/w two dates based on the Dia Of Bar

To Calculate the qty b/w two dates
 

Excel 2007 PivotTable
No formulas needed.
Data in/out dynamic.
http://www.mediafire.com/file/xcyzmezlnaw/05_12_09.xlsx