HI Ajit. I sincerely appreciate your solutions and your contribution to this group.
looking at your solution I want to know what does this formula means and how it works =SUM(IF(TEXT(B2:B13,"[EMAIL PROTECTED]/000\/00* ")=B2:B13,IF(ISERR(SEARCH("/",TEXT(B2:B13,"[EMAIL PROTECTED]/000\/00*")))=FALSE,D2:D13))) Rgds Mayank On Sat, Oct 18, 2008 at 7:17 PM, AJIT NAVRE <[EMAIL PROTECTED]> wrote: > Pls find attached the file.... > > Regards > > Ajit > > On Sat, Oct 18, 2008 at 2:08 PM, Ahmedhonest <[EMAIL PROTECTED]>wrote: > >> >> Dear All, >> >> A warm Greetings to all. Please find the attach file to this mail and >> request you all Guys to provide me the solution and have patients in reading >> the file throughly. >> >> Hoping that there is a Prompt reply and I Thanks each and every individual >> in advance for all your suggestions. >> >> Regards >> -- >> Ahmed Bawazir >> >> >> >> > > > -- > Thank You, > > Ajit Navre > > > > -- Regards Mayank Patel 9822978041 9422749110 --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---