May 31 2021 07:11 AM
May 31 2021 09:08 AM
Unless there's some compelling reason to have the series of values in a row instead of a column, a very clean way to accomplish this ongoing series is to create a table, to which you can add values ad-infinitum (almost). And the formula can read very simply =AVERAGE(Table1[Values]) as shown in the image below. I've also attached the spreadsheet that I created to illustrate this approach.
Jun 01 2021 03:15 AM
Jun 01 2021 06:45 AM - edited Jun 01 2021 07:01 AM
Yes. And (IMHO) you should redesign it. And it takes nothing more than a Copy.....Paste Special (in which you select the Transpose option). See the attached. Then just designate that an Excel Table. I've created a couple of averages in the attached.
In Excel, a database typically works better if each new row is added to the bottom. What you have is exactly that: a database. Many of the functions, although they can work with data arrayed as you have it, are more effectively deployed with the records stacked on top of one another. If you search through Google or YouTube for examples of people working in Excel with tables of data, you will find almost invariably--I'm confident in this--that the tables are arrayed vertically, not horizontally.