Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding data only if adjacent to cell labeled "male"/"female" | Excel Worksheet Functions | |||
How do I use "sumif" for cells "0" across multiple ranges? | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
=SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions |