Dear Vikas, To come up with a possible solution to your query, I had to alter an UDF (User Defined Function) that was available on Internet (thanks to the original programmer).
Here's what it will do: *It would check the number format (or currency format, you may wish to say) of the cell you provide and would sum all the cells in the given range who have that same number format as the cell it is checking at first.* I think that's what you need. Please see the attached file wherein I have described the UDF with examples. Let me know if it solves your purpose or you require any further help with this. Cheers! AJ On Fri, Mar 5, 2010 at 4:56 PM, rf1234 rf1234 <rfhyd1...@gmail.com> wrote: > Hello Dear, > First Perform the operation required(+,-,*,/ or %) what ever, > then select the range go to cell formatting,currency,and symbole. > > > Hope it will help > Happy To Help > :) > Shyam > > > > > > > On Fri, Mar 5, 2010 at 12:49 PM, Vikas Chouhan <vikask...@gmail.com>wrote: > >> >> >> Dear All, >>> >>> (i am using 2003 office) >>> >>> >>> if multiply currency (exp. Doller,Rupees,Catalan,Finnish,euro) in one >>> column (a1:a10) how i get the sum doller, rupees or more currency in >>> different column >>> >>> >>> -- >>> One Team One Dream One Goal >>> >>> Warm Regards, >>> Vikas Chauhan >>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com, >>> 9911868518, >>> "We can't Spell S_ccess without U" >>> >>> Life is Very beautiful !!! >>> ¨`•.•´¨) Always >>> `•.¸(¨`•.•´¨) Keep >>> (¨`•.•´¨)¸.•´ Smiling! >>> `•.¸.•´. >>> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our Facebook Group @ >> http://www.facebook.com/group.php?gid=287779555678 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,800 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Demo.xls
Description: MS-Excel spreadsheet
