Hi Venkat, Sounds like a job for SUMPRODUCT. We 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 _________________________________________________________________ Looking to change your car this year? Find car news, reviews and more http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
