Forum Discussion
Varying Cells Ranges in a Formula, without VBA
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).
DidierDeBordeaux You wrote "And even don't see where to find the answer." Did you see the file I attached and click in cells A1, B1, G1 and H1?
As for sending a screenshot, use the camera symbol (far right of the picture below) above the area where you write your message.
If you still don't succeed, send me a direct message (click on my name tag and press Message)
""You wrote "And even don't see where to find the answer." Did you see the file I attached "
---> Yes I have seen and open it"
-----> Well; I realise that I had only open the preview! ^_^ ~~ Now I have opened it in Excel and then Yes Indeed, I have seen your 2 kinds of Formulas 🙂 ~~ My body is very sleepy right now so I will postpone a Better Study of them but looks it might be what I was looking for 🙂 ~~ Thanks a Lot for your Nice help, Dear Riny : )🙂❤️- "You wrote "And even don't see where to find the answer." Did you see the file I attached " ---> Yes I have seen and open it 🙂
"and click in cells A1, B1, G1 and H1?" --> I didn't know I could do that, I will try it 😉
"As for sending a screenshot, use the camera symbol (far right of the picture below) above the area where you write your message." ---> I didn't noticed these tools, I guess I need to "open full text editor".