HI Skanda SEE ATTACHED EXCEL FOR SOLUTION
LET ME KNOW JAYAVELY 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, > > > > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Copy of paracept.xls
Description: MS-Excel spreadsheet