Well, I think it is going to work, but again I ran into a snag. I calculate this monthly, and each month has its own sheet. So I have a spot on the bottom of each broker's page that keeps a running total of their year to date 1st year clients, year to date 2nd year clients, and year to date 3rd year clients... I think these are the cells I need in the formula, so when I enter a new check, it is added to the year to date total, and then from there it figures out what tier it falls into.. So which cells would I modify in the formula to reference the year to date cells, rather than just the total of the checks I enter this month?? Would it be on the commission side or the check side??