Forum Discussion
Varying Cells Ranges in a Formula, without VBA
Hello. Is there someone to tell me how to Vary Cells Ranges in a Formula, without VBA. For example, I would like to make the Sum of a series of ranges of cells which varies in the formula in fu...
DidierDeBordeaux Not entirely sure how your data is organised and where you want to add the SUM formulae, but perhaps the attached workbook helps.
The first example assumes that you have columns with continuous data from which you want to sum specific (smaller) blocks of data. The other assumes that you have smaller blocks of data moving across columns and down for every week. In the latter case, the formula is simple. For the first, it becomes a bit less straight-forward. See if you can get it to work in your own schedule(s).
Riny_van_Eekelen Very Thanks for Your Informations. I will study them right now. But I Understand that it was not very Clear for You to know what I Meant or Need! 😛 Regards, Didier 🙂