see attachhed file for your query On Thu, Oct 23, 2008 at 12:14 PM, 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 > > > > -- Lakshmanan T. S. (Gmail), A-15/6, Shree Ram Nagar, S.V.Road, Andheri West, Mumbai 400058, INDIA Tel:+91 9987754235 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Book2.xls
Description: MS-Excel spreadsheet
