Is there a way to represent a number many times inside of a function, without typing it in the same number of times in a table?

[J Blizzard]

I'm inputting values into a spreadsheet from a printed report. If there are 18 storage units, 15 of them rent for $60, and the remaining units rent for a few different values, is there a way to avoid the following method AND avoid entering everything on my printed report (dozens of pages) into a table to do a weighted average?

I'm looking for some way to represent the "60" value multiple times in the string, like a While Loop or similar. Contextually it would look like the following, but obviously that isn't sufficient:

 

[Joe4]

Why would you be writing the numbers in your formula directly?
Usually, you would reference a range of cells, that hold those values!

However, if you are going to write the numbers directly into the formulas, create a manual AVERAGE formula. The AVERAGE is just the sum of all the value divided by the number of the values, i.e.

=SUM((60*15),43,80,200)/(15+3)

 

[Fluff]

Another option is

=AVERAGE(SEQUENCE(,15,60,0),43,80,200)

 

[J Blizzard]

Average and sequence looks like a working step for my use! I was hoping for like, average(weight(60,15),43,80,200) or something intuitively similar. This is very close and I'll be using it. Thank you! The reason for writing numbers into the formula directly is to avoid typing in dozens of sheets of paper. It's already mind numbing.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Joe4]

Glad you found a solution that works for you.

The reason for writing numbers into the formula directly is to avoid typing in dozens of sheets of paper. It's already mind numbing.

One advantage to typing them in was if you had 15 occurrences of a number, you would only need to type it once, and then you could copy/paste/drag down for the other 14.
And you could have a reusable form where you only have to enter the formulas once, and just enter numbers to change things.
But use whatever suits your needs the best!