Mr Science.

Thanks, this works but how do I get it to stop performing the
calculation after a certian number of cells. What I am creating is a
revenue recognition model and it needs to find the first cell that has
numbers in it and divide that by the number of periods it is being
amortized for, but after those periods it needs to stop and look for
the next value and do the same thing. Its a bit more dynamic then I am
used to. Thanks for your help