|
| 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
May 12th, 2009, 10:00 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
May 12th, 2009, 10:28 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
|
#3
May 12th, 2009, 10:43 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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  100)-- 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
|
|
#4
May 13th, 2009, 12:20 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
