Brilliant!
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Dilip Pandey Sent: Tuesday, May 05, 2009 5:08 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Sum Hi Skanda, Please find the attached solution. Thanks & Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Sat, May 2, 2009 at 1:24 AM, Skanda <skanda.pokkun...@gmail.com> wrote: Columns A and B give the sum of ceizg and paracept in each row. Is there any formula that sums all the values of "Ceizg" ad "Paracept". e.g:96,00 is the sum of all "paracept" in the first row. 4,600 is the sum of all "Ceizg" in the second row. I gave only partial data. I have about 50K rows and its very difficult to do summation manually. Thanks for your help in advance, __________ ESET NOD32 Antivirus - Vírusdefiníciós adatbázis: 4052 (20090504) __________ Az üzenetet az ESET NOD32 Antivirus ellenõrizte. http://www.eset.hu __________ ESET NOD32 Antivirus - Vírusdefiníciós adatbázis: 4054 (20090505) __________ Az üzenetet az ESET NOD32 Antivirus ellenõrizte. http://www.eset.hu --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---