YES! So that was it, every time I would enter in the formula and then change the "applies to" range afterwards, never checking the cell references for the formula again.

Thanks very much to both of you for your help and patience.