You can do a pivot table or try the sumif function Nishant
On Oct 23, 11:44 am, "Santhosh Kumar M K" <[EMAIL PROTECTED]> wrote: > Dear Friends, > > Please, solve my problem.... > > Find the attached data.. > > How to calculate total premium amount for a single person....using formula / > function....? > > *Agent Name* > *Month * > *Colleted Date* > *Premium amount* > Ramesh > Feb > 2/8/2008 > 5,000.00 > Satish > Feb > 2/15/2008 > 15,000.00 > Raju > Feb > 2/25/2008 > 7,895.00 > Venki > Feb > 2/26/2008 > 5,264.00 > Shiva > Feb > 2/7/2008 > 8,562.00 > Rakesh > Feb > 2/10/2008 > 45,632.00 > Ramesh > Mar > 3/14/2008 > 885.00 > Satish > Mar > 3/16/2008 > 80,000.00 > Raju > Mar > 3/5/2008 > 9,465.00 > Venki > Mar > 3/20/2008 > 45,222.00 > Shiva > Mar > 3/29/2008 > 75,444.00 > Rakesh > Mar > 3/2/2008 > 9,542.00 > Ramesh > Apr > 4/4/2008 > 75,463.00 > Satish > Apr > 4/6/2008 > 35,265.00 > Raju > Apr > 4/15/2008 > 85,648.00 > Venki > Apr > 4/27/2008 > 95,624.00 > Shiva > Apr > 4/20/2008 > 8,000.00 > Rakesh > Apr > 4/9/2008 > 1,523.00 > Ramesh > May > 5/5/2008 > 20,000.00 > Satish > May > 5/6/2008 > 754,666.00 > Raju > May > 5/30/2008 > 854,231.00 > Venki > May > 5/21/2008 > 989,898.00 > Shiva > May > 5/26/2008 > 656,565.00 > Rakesh > May > 5/6/2008 > 896,565.00 > > Thanks in advance. > Rgds, > > Santhosh > > Book134.xls > 25KViewDownload --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
