I think I did a poor job of explaining. I'll try again and repost.
"Kathleen" wrote:

Hi,

I'm working with payperiods, 1-26. Each payperiod will have either a
payment amount due or is marked na. If payperiod 5 is the beginning of the
amounts due then the previous ones will be marked na. Each payperiod column
has formula to figure out if there should be an amount due or an na. What I
need is for the amounts due to have a total of 6 payperiods and the remaining
payperiods to override the columns existing formula and say "end of 12
weeks". Amounts due would be consecutive. I can have only amounts due for 6
payperiods in total.