$ Symbol

alexr8 · Aug 23, 2011

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 · Aug 23, 2011

Me love you love you long time, you give me $1

How's that?

Sorry, it's that time of night.

EvanDavis · Aug 24, 2011

$ sign allows you to set a column or row value in an equation as static.

alexr8 · Aug 28, 2011

Thank you!
Now, can you give me an example?

SUMIF question - again	5	Feb 4, 2005
how to get actual percentage format instead of 100 multiplied	4	May 30, 2007
Help with SUMIF	1	Feb 3, 2005
vba macro that allows insertion of symbols at cursor	0	Jan 4, 2021
Creating a value from a variable result	1	Apr 19, 2010
"anchor symbol"-how to get rid of	6	Jan 23, 2009
How do I read Json results from yahoo	5	Jun 21, 2010
Excel macro help needed	0	Oct 20, 2016

Ask a Question