RE: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Rajan_Verma
Try sumifs() =SUMIFS(C3:C7,A3:A7,G5,B3:B7,F5) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sudhir Kumar Sent: Thursday, September 01, 2011 5:00 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Book2.xlsx Dear All Please suggest

Re: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread dguillett1
=SUMPRODUCT((B3:B22=F5)*(A3:A22=G5)*C3:C22) From: Sudhir Kumar Sent: Wednesday, August 31, 2011 6:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Book2.xlsx Dear All Please suggest a formula of Sumproducts Thanking u

Re: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Venkat CV
** > > ** ** > > Kelvin Elec. > > 30-Aug > > 1 > > ** ** > > 8/30/2011 > > Vijeta Elec-BR-DDN > > 3 > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > &

Re: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Mahesh parab
> > ** ** > > 8/30/2011 > > Vijeta Elec-BR-DDN > > 3 > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > ** ** > > HI > > ** ** > > I WAN

FW: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Sudhir Kumar
Of Mahesh parab Sent: Wednesday, August 31, 2011 4:38 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Book2.xlsx Hi Try =SUMPRODUCT((A3:A7=G5)*(B3:B7=F5)*(C3:C7)) OR =SUMIFS(C3:C7,A3:A7,G5,B3:B7,F5) On Wed, Aug 31, 2011 at 5:05 PM, Sundarvelan N wrote

RE: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Sudhir Kumar
: Wednesday, August 31, 2011 4:35 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Book2.xlsx Please refere the attached file. Thanks N.Sundarvelan 9600160150 On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar wrote: Dear All Please suggest a formula of Sumproducts

Re: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Mahesh parab
Hi Try =SUMPRODUCT((A3:A7=G5)*(B3:B7=F5)*(C3:C7)) *OR* =SUMIFS(C3:C7,A3:A7,G5,B3:B7,F5) On Wed, Aug 31, 2011 at 5:05 PM, Sundarvelan N wrote: > Please refere the attached file. > > > Thanks > N.Sundarvelan > 9600160150 > > > > On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar > wrote: >

Re: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Venkat CV
Hi Sudhir, Try this *=SUMPRODUCT((B3:B7=F5)*(A3:A7=G5)*(C3:C7))* *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar wrote: > Dear All > > ** ** > > Please suggest a formula of Sumprodu

Re: $$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Sundarvelan N
Please refere the attached file. Thanks N.Sundarvelan 9600160150 On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar wrote: > Dear All > > ** ** > > Please suggest a formula of Sumproducts > > ** ** > > Thanking u > > -- > > --

$$Excel-Macros$$ Book2.xlsx

2011-08-31 Thread Sudhir Kumar
Dear All Please suggest a formula of Sumproducts Thanking u -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedI