View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WLMPilot WLMPilot is offline
external usenet poster
 
Posts: 470
Default Adding "moving" ranges

This may be simplier than I can think of right now. I have 12 monthly
budgets on a worksheet. Two of the columns in each budget indicate INCOME and
EXPENSES.

One income is fixed on the 15th and 30th and the other income is every two
weeks, which is where I come up with the "moving" range.

Here is a sample view:

Exp1
Exp2
Exp3
Inc1 <--Every 2 weeks
Exp 4
Exp 5
Inc2 <--15th
Exp 6
Inc 1 <--Every 2 weeks
Exp 7
Exp 8
Inc 2 <--30th
Exp 9

I want to be able to have a formula that can locate each income and sum the
expenses between each paycheck. Because Inc1 is not fixed on a specific
date, I am not sure how to do this.

Thanks,
Les