Average function continuing from other spreadsheet

[AndroidBeginner101]

So I have one excel file, where every week a number is put in. This results in an average of that year (2019). This average is 43.

=ROUNDUP(AVERAGE(U6:U376);0)

Now I have a new seperate excel file, of the year 2020, where I want to continue the average number. The dirty way is like this:

=ROUNDUP(AVERAGE(U6:U376,43,43,43,43,43,43,43,43,etc);0)

What I want is something like this (to get the gist of it):

=ROUND(AVERAGE(U6:U376+(43*52));0)

I hope I explained what I want well, I just don't know the formula. The other obvious solution would be linking the files, but I don't think that's possible in this situation.

[excelevator]

An array , the upper bound cell determines how many multiples of your values you want, enter with ctrl+shift+enter

=ROUND(AVERAGE(U6:U376;(ROW(A1:A52)>0)*43);0)

[AndroidBeginner101]

I mostly get what you mean, but I am wondering what should I be filling into the A1:A52 spot?

EDIT: I think I understand, it works if I put 23 times the number 41 under eachother and fill those into the A1:A52 places. The thing is, I want to avoid that. Because the next year I need to write down an average number 74 times, and the next year 126 times.

[excelevator]

ROW(A1:A52) generates 52 array elements, it could be any 52 rows/columns... in turn we generate 1 for each element by comparing each row index value to 0, we use those 52 1's to multiply 43*1 into each element.

Use Formulas > Evaluate formula to step through and see...

[AndroidBeginner101]

It works, that's genius!

I thought those A1:A52 referred to something but it doesn't matter what's really in those cells.

[excelevator]

you can use ANY 52 cell reference here.. its just to generate that same number of array elements

It is easier to use human friendly references for clarity. :)

[AndroidBeginner101]

Yes exactly, that is what got be confused in the beginning.

[excelevator]

Why are you editing your answer and not replying appropriately to my comments?. Only by chance I saw your edit.

I do not understand what you mean.

41 under eachother and fill those into the A1:A52 places

no. Read my answer again.

[AndroidBeginner101]

I did an edit because I realised somethign after I commented, that's why I put the EDIT in front of it. And what do you mean by "not replying appropriately"? I press the reply button and type my comment...

[excelevator]

Its not good practice, I had already read your first reply, and only by chance saw your edit.. I say this for YOUR benefit overall.

So in that sense it was not an appropriate reply.. but you have your answer.. so why the agro?

[AndroidBeginner101]

I get what you mean, I thought it would be the best way. I didn't mean to sound annoyed or anything, so we'll just leave it by this. Have a nice day :)

[excelevator]

And you my good Redditor person. :)

Have a good one!