Help!

To Calculate the qty b/w two dates

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions RSS
Next:  Is it possible to force outlook to check for text..  
Author Message
vmohan1978
External


Since: Jan 29, 2009
Posts: 5
PostPosted: Tue May 12, 2009 2:00 am    Post subject: To Calculate the qty b/w two dates
Archived from groups: microsoft>public>excel>worksheet>functions (more info?)
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
Back to top
vmohan1978
External


Since: Jan 29, 2009
Posts: 5
PostPosted: Tue May 12, 2009 2:28 am    Post subject: RE: To Calculate the qty b/w two dates [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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
>
>
>
>
Back to top
Jacob Skaria
External


Since: Mar 04, 2009
Posts: 441
PostPosted: Tue May 12, 2009 2:43 am    Post subject: RE: To Calculate the qty b/w two dates [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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
> >
> >
> >
> >
Back to top
Herbert Seidenberg
External


Since: Jan 08, 2009
Posts: 57
PostPosted: Tue May 12, 2009 4:20 pm    Post subject: Re: To Calculate the qty b/w two dates [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Excel 2007 PivotTable
No formulas needed.
Data in/out dynamic.
http://www.mediafire.com/file/xcyzmezlnaw/05_12_09.xlsx
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Worksheet Functions All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum