Weekly sum (5 days by 5 or 7 by 7.) based on dynamic criteria.
Asked Jul 16, 2009, 03:11 AM
I'd like to make a weekly sum but with a dynamic criteria which I can choose.
I have a column with a formula that gives me negative and positive values. The weekly sum only starts when this column is above or equal 1. I want to sum 5 by 5 days (5 by cells from another page in the spreadsheet) by order of appearance.
Somewhat I could manage a formula to do this but it only works with increasing values (using SMALL formula) but it doesn't work if the third sum of 5 days is less than the second, or the fifth is less than the first... or, etc... because the column used to calculate varies with positive values and negative values, e.g, is has expenses and incomes.
Basically, I want to do a Weekly (choosing n-days) Sum but with the flexibility to choose which day is the starting cell (1st Monday, 1st Tuesday, or the 2nd Friday, 2nd Sunday.. ) and how many days I want to sum ( 2 by 2, 3 by 3, 5 by 5, 7 by 7)...
I hope the images attached (2 examples) can help you to help me to solve this problem...
P.S: I don't know how to use macros very well...