What does the "$" symbol do to a cell value in a formula.
 

for example, sumif($c2:$c8,"3",$f2:$f8)

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)

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)