Hi!

The $ sign makes that reference absolute. In other words:

$C2:$C8 and $F2:$F8

Those references are "locked" onto column C and column F.

If you were to copy that formula to some other location the column
references are absolute and would not change.

The same thing applies to the row portion of the reference:

C$2:C$8 and F$2:F$8

You can also make everything absolute:

$C$2:$C$8 and $F$2:$F$8

In this case both the column and the row references are "locked"

Biff

"Vernita" wrote in message
...
for example, sumif($c2:$c8,"3",$f2:$f8)