Re: $$Excel-Macros$$ Product wise total sale between two dates

2011-06-10 Thread Kal xcel
perfectly working. Ashish, thanks a lot.Tusi gr8 ho... On Fri, Jun 10, 2011 at 5:29 AM, ashish koul wrote: > try this > > > c6= =SUMIFS('Sale Data-10-11'!E:E,'Sale Data-10-11'!A:A,Final!B6,'Sale > Data-10-11'!D:D,">="&Final!$C$4,'Sale Data-10-11'!D:D,"<="&Final!$C$5) > > On Th

Re: $$Excel-Macros$$ Product wise total sale between two dates

2011-06-09 Thread ashish koul
try this c6= =SUMIFS('Sale Data-10-11'!E:E,'Sale Data-10-11'!A:A,Final!B6,'Sale Data-10-11'!D:D,">="&Final!$C$4,'Sale Data-10-11'!D:D,"<="&Final!$C$5) On Thu, Jun 9, 2011 at 7:21 PM, Kal xcel wrote: > Dear Experts, > > I need a help to get product wise total sale between two dates. > > Please