On Sat, 10 Oct 2009 21:09:40 -0400, "Linda RQ"
wrote:

Ron,

What do the $ do/mean? Your results were the same as Daves.

Thanks,
Linda

Check HELP for "Addressing" or Absolute Address.
Excel has several modes of addressing cells: Absolute, Relative, and mixed.

If you drag Dave's formula to another cell, the cell references will change.

If you drag a formula with absolute addresses to another cell, cell references
preceded by the "$" will not change.

This can be useful if you want a reference to a data table to remain constant,
while the reference to a lookup value changes.

In this particular case, since the "<10" is not a cell reference, it won't make
any difference.

But if the "<10" was replaced by a cell reference; e.g. "<"&M7 and you had a
series of values in M7:M9 that you wished to evaluate against, you could enter
a formula in N7 and fill down to N9; the table reference would remain the same,
and the "lookup reference" would adjust.
--ron