hi venkat.... find the solution sheet attached... On Wed, May 27, 2009 at 8:04 PM, Norman May <nor...@gmail.com> wrote:
> 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Book1 (1).xls
Description: MS-Excel spreadsheet
