Specific formula for each day and component for the entire year

[Mr Van Zuilen]

I have made a formula which corresponds to certain components.

I need to make this formula for each day of the year for 9 components, using information from another worksheet in the file.

However the cell range is from e.g. 1:23 for the second day it is 24:47, so forth.
I cannot drag this formula down because then excel will do e.g. first day: 1:23 second day 2:24.

Is there an easy way to set up this formula so that Excel regonizes it has to take a range of 23 cells?

This is the exact formula I am using
=SUMIF('Raffinage lijst 2021'!$AD5:$AD28;VerbandsControle!AC$4;'Raffinage lijst 2021'!$AJ5:$AJ28) (cell AC6)
=SUMIF('Raffinage lijst 2021'!$AD29:$AD52;VerbandsControle!AC$4;'Raffinage lijst 2021'!$AJ29:$AJ52) (cell AC7)

AC$4 is one of the 9 components (so last component = AK$4)
these need to remain the same.

 

[EFANYoutube]

Hi
Indirect is probably what you need
You can reference a cell by using a string like =INDIRECT("A"&E2) This is =A5
I have put the row number I want in E column and this code gets the value from A column

1​
2​				5​	5​
3​				10​	10​
4​				15​	15​
5​				20​	20​
6​
7​
8​
9​
10​
11​
12​
13​
14​
15​
16​
17​
18​
19​
20​
21​
22​

 

[Mr Van Zuilen]

EfanYoutube thank you for your answer, it is not the answer I am looking for.
But you have given me new insights which will enable me to carry out the document.
I highly appreciate your efforts!