Home |
Search |
Today's Posts |
#1
|
|||
|
|||
What does the "$" symbol do to a cell value in a formula.
for example, sumif($c2:$c8,"3",$f2:$f8)
|
#2
|
|||
|
|||
The "$" symbol does not do anything to the value of the cell. What it does
do is hold the reference to the location of the cell if you were to drag to formula. Your cell value could also appear as: sumif($c$2:$c$8,"3",$f$2:$f$8) which would not effect the value of your calculation. "Vernita" wrote: for example, sumif($c2:$c8,"3",$f2:$f8) |
#3
|
|||
|
|||
Thanks!
"StinkeyPete" wrote: The "$" symbol does not do anything to the value of the cell. What it does do is hold the reference to the location of the cell if you were to drag to formula. Your cell value could also appear as: sumif($c$2:$c$8,"3",$f$2:$f$8) which would not effect the value of your calculation. "Vernita" wrote: for example, sumif($c2:$c8,"3",$f2:$f8) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copying cell names | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Triangle symbol in cell. What does it mean. How do I delete this | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |