Hi Sukumar, $ is used for making the range static. i.e making the range fixed and it will not chnage even if you copy paste the same formula in below cells. eg. lets say u have data from Cells A2 to A20 if you write your formula in B2 as =sum(A2:A20) and copy paste the same formula in cell B3 you will see formula as =sum(A3:A21). on the other hand if you make it static i.e. =SUM($A$2:$A$20) and paste it B3, B4 and so on.. its range will remain the same i.e. even in B3 formula will remain as =SUM($A$2:$A$20)
to make the range static jus press F4 when you select the range i.e. in above case wen u write =Sum(A2:A20 immediately press F4 the formula will convert to =SUM($A$2:$A$20 and then continue let me know if it works. ________________________________ From: D M Sukumar <vijayajith...@gmail.com> To: excel-macros@googlegroups.com Sent: Sat, 29 January, 2011 11:03:37 PM Subject: RE: $$Excel-Macros$$ Please help Hai groups, Can you tell me what is the use of $ sign excel;;;; And can you give some examples please;;; Thank you From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com akoul.wordpress.com My Linkedin Profile PBefore printing, think about the environment. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel