Re: $$Excel-Macros$$ Book2.xlsx
Hi Sudhir, Try this *=SUMPRODUCT((B3:B7=F5)*(A3:A7=G5)*(C3:C7))* *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote: 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book2 query(venkat).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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 sudhir.ku...@lazerindia.comwrote: 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Book2.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
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 nsund...@gmail.com wrote: Please refere the attached file. Thanks N.Sundarvelan 9600160150 On Thu, Sep 1, 2011 at 5:00 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote: 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Book2.xlsx
Data Table Date Party Name Amount Hi can u suggest here for Sumproduct formula 8/30/2011 Anuvanshika -Kanpur 3 8/30/2011 Kelvin Elec. 49649 Name of Parties Date Amt. 8/30/2011 Anand Agencies 15 Kelvin Elec. 30-Aug 49649 8/30/2011 Kelvin Elec. 1 Kelvin Elec. 30-Aug 1 8/30/2011 Vijeta Elec-BR-DDN 3 HI I WANT RESULT IN From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sundarvelan N Sent: 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 sudhir.ku...@lazerindia.com wrote: 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Book2.xlsx
Hi not sure what exactly you looking for, even if you *sort* the Party Name column you will get results as per highlighted in yellow thanks Mahesh On Thu, Sep 1, 2011 at 5:46 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote: *Data Table* * * * * ** ** ** ** ** ** ** ** ** ** ** ** Date Party Name Amount ** ** ** ** *Hi can u suggest here for Sumproduct formula* 8/30/2011 Anuvanshika -Kanpur 3 ** ** ** ** * * * * * * * * 8/30/2011 Kelvin Elec. 49649 ** ** ** ** *Name of Parties* *Date* *Amt.* ** ** 8/30/2011 Anand Agencies 15 ** ** ** ** Kelvin Elec. 30-Aug 49649 ** ** 8/30/2011 Kelvin Elec. 1 ** ** ** ** Kelvin Elec. 30-Aug 1 ** ** 8/30/2011 Vijeta Elec-BR-DDN 3 ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** HI ** ** I WANT RESULT IN ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Sundarvelan N *Sent:* 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 sudhir.ku...@lazerindia.com wrote: 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ** ** -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Book2.xlsx
Hi Sudhir, For sumproduct we must have 2 fixed data criteria..in this scenario we cant use SUMPRODUCT *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* * * On Thu, Sep 1, 2011 at 5:46 AM, Sudhir Kumar sudhir.ku...@lazerindia.comwrote: *Data Table* * * * * ** ** ** ** ** ** ** ** ** ** ** ** Date Party Name Amount ** ** ** ** *Hi can u suggest here for Sumproduct formula* 8/30/2011 Anuvanshika -Kanpur 3 ** ** ** ** * * * * * * * * 8/30/2011 Kelvin Elec. 49649 ** ** ** ** *Name of Parties* *Date* *Amt.* ** ** 8/30/2011 Anand Agencies 15 ** ** ** ** Kelvin Elec. 30-Aug 49649 ** ** 8/30/2011 Kelvin Elec. 1 ** ** ** ** Kelvin Elec. 30-Aug 1 ** ** 8/30/2011 Vijeta Elec-BR-DDN 3 ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** ** HI ** ** I WANT RESULT IN ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Sundarvelan N *Sent:* 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 sudhir.ku...@lazerindia.com wrote: 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel ** ** -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Book2.xlsx
=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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Book2.xlsx
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 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 LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel