Dec 26 2021 02:13 PM
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 function of the column.
Like:
My idea was to create:
I wanted to create formulas like:
But Excel doesn't accept it :\ so sorry if I can't give You the example in a existing spreadsheet.
If You are sure it is not possible without VBA, would You be Kind Enough to suggest a model of code I could copy-paste and work with? please
Regards,
Didier
Microsoft® Excel® pour Microsoft 365 MSO (Version 2111 Build 16.0.14701.20254) 64 bits
Dec 26 2021 10:14 PM
@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).
Dec 27 2021 05:13 PM
@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! :p Regards, Didier :)
Dec 27 2021 05:49 PM
Dec 27 2021 05:52 PM
Dec 27 2021 10:25 PM
@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)
Dec 28 2021 11:51 AM
Dec 28 2021 12:01 PM - edited Dec 28 2021 12:02 PM
""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 : ):)<3