I now know how to keep the formula from changing it's reference when I drag, thanks to this forum. Still trying to figure out the two questions above though.
Ky