Hi Skanda, I just realized that you would want to sum all the cells with the headings either Paracept or Ceizg at one go.
In that case you can simply use the formula: =SUMPRODUCT((C2:BD2="CEIZG")*C3:BD5) -- for "CEIZG" Please replace the cell references as per your original range. =SUMPRODUCT((C2:BD2="Paracept")*C3:BD5) -- for "Paracept" Please replace the cell references as per your original range. Please let me know if this helps. Regards, Andy On Sat, May 2, 2009 at 12:07 PM, Aindril De <aind...@gmail.com> wrote: > Hi Skanda, > > Please find attached the solution file. > > Regards, > Andy > > On Sat, May 2, 2009 at 2:54 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
