thank you macropod. I will try out that formula and see if I have any problems. My question for you. I'm new to Excel and what what those "$" signs mean and how you use them. What would happen if you left that out of the formula? What results will you get in comparison to using the "$" sign?