Paste the following formula on sheet 2 cell B5: =SUMPRODUCT((Sheet1!$C$5:$C$50000)*(Sheet1!$B$5:$B$50000=A5))
Norman On Wed, May 27, 2009 at 7:47 AM, venkat sudhakar <sudhakar...@gmail.com>wrote: > Dear Friends, > > Please find sample file attached. > > Regards, > Venkat. > > > On 27/05/2009, Dave Bonallack <davebonall...@hotmail.com> wrote: >> >> Hi, >> Sounds like a job for SUMPRODUCT >> I could probably do the needful if you attached a sample worksheet. >> Regards - Dave. >> >> ------------------------------ >> Date: Wed, 27 May 2009 09:19:07 +0530 >> Subject: $$Excel-Macros$$ Formula needed >> From: sudhakar...@gmail.com >> To: excel-macros@googlegroups.com >> >> Dear Friends, >> >> I need a formula for my work. >> >> There will be 2 Excel sheets. >> >> In First Sheet there will be 2 Columns >> >> In First column there will be code and in 2nd column there will be value >> and 'n' number of rows will be there. And the code may be repeated at >> several times in different rows. >> >> And in second sheet also, there will be 2 columns >> >> In first column there will be code. >> >> Now what i need is, against each item code in second sheet, the sum of >> values in first sheet representing corresponding code. >> >> Can any one do the needful. >> >> Regards, >> >> Venkat >> >> >> --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
