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
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
Book134.xls
Description: MS-Excel spreadsheet
