A alexr8 Joined Aug 23, 2011 Messages 2 Reaction score 0 Aug 23, 2011 #1 What does the '$' symbol mean in excel? I have here an example: =SUMIF($E$12:$S$12;"w";E27:S27) Can you give me a simple example of how to use it?
What does the '$' symbol mean in excel? I have here an example: =SUMIF($E$12:$S$12;"w";E27:S27) Can you give me a simple example of how to use it?
floppybootstomp sugar 'n spikes Moderator Joined Mar 5, 2002 Messages 20,281 Reaction score 1,794 Aug 23, 2011 #2 Me love you love you long time, you give me $1 How's that? Sorry, it's that time of night.
EvanDavis Silly Fool Joined Jun 20, 2010 Messages 5,307 Reaction score 688 Aug 24, 2011 #3 $ sign allows you to set a column or row value in an equation as static.
A alexr8 Joined Aug 23, 2011 Messages 2 Reaction score 0 Aug 28, 2011 #4 Thank you! Now, can you give me an example?