You can use SUMIF function. 2009/5/6 Samir Agayev <saga...@gmail.com>
> Dear Group members, > > In attached excel file, I have a little vba code. > > It gets data from Column B in Sheet2 to Column D in Sheet1 if Column D in > Sheet2 equals Column A in Sheet1. > > The only problem occurs when the Items of Column D in Sheet2 are not > unique. You can see there three 15-May-09. So it gets only the last data, > which is 100,000,000.00 (at B19 in Sheet2), and ignores B17 and B18). > > Is there any way of improving this code to get the sum of B17, B18 and B20 > into D13 in Sheet1? > > Thank you in advance. > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
