Discussion Re: Calculating values in a row in Excel
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2401526#M101849
<P><LI-USER uid="1067610"></LI-USER> </P><P> </P><P>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.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mathetes_0-1622477052371.png" style="width: 524px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/285130i501974EF321E217C/image-dimensions/524x468?v=v2" width="524" height="468" role="button" title="mathetes_0-1622477052371.png" alt="mathetes_0-1622477052371.png" /></span></P><P> </P>Mon, 31 May 2021 16:08:03 GMTmathetes2021-05-31T16:08:03ZCalculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2401281#M101837
<P>I need to calculate the average values in a row and it is to be updated daily.</P><P>I need to always use the same start cell, but the value will change with each new days value.</P>Mon, 31 May 2021 14:11:54 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2401281#M101837eingram252021-05-31T14:11:54ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2401347#M101842
<P><LI-USER uid="1067610"></LI-USER> </P>
<P>You might use a formula such as =AVERAGE(D2:ZZ2) since AVERAGE ignores empty cells.</P>Mon, 31 May 2021 14:38:44 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2401347#M101842Hans Vogelaar2021-05-31T14:38:44ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2401526#M101849
<P><LI-USER uid="1067610"></LI-USER> </P><P> </P><P>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.</P><P> </P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mathetes_0-1622477052371.png" style="width: 524px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/285130i501974EF321E217C/image-dimensions/524x468?v=v2" width="524" height="468" role="button" title="mathetes_0-1622477052371.png" alt="mathetes_0-1622477052371.png" /></span></P><P> </P>Mon, 31 May 2021 16:08:03 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2401526#M101849mathetes2021-05-31T16:08:03ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403347#M101909
<P><LI-USER uid="425987"></LI-USER> </P><P>I would have to redesign the spreadsheet.</P>Tue, 01 Jun 2021 10:11:02 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403347#M101909eingram252021-06-01T10:11:02ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403352#M101910
I need the first cell to remain the same, but each day an additional cell is added. If I simply copy the formula to the next day, the first cell is changed.<BR />See the spreadsheet I attached to mathetes answer.Tue, 01 Jun 2021 10:15:54 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403352#M101910eingram252021-06-01T10:15:54ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403385#M101912
<P><LI-USER uid="1067610"></LI-USER> </P>
<P>Change B3 to $B3 in the formula. This will "fix" the column letter B.</P>Tue, 01 Jun 2021 10:45:53 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403385#M101912Hans Vogelaar2021-06-01T10:45:53ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403956#M101927
<P><LI-USER uid="1067610"></LI-USER> </P><P> </P><P>Yes. And (IMHO) you <EM>should </EM>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.</P><P> </P><P>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 <EM>can</EM> 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.</P>Tue, 01 Jun 2021 14:01:23 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2403956#M101927mathetes2021-06-01T14:01:23ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2404200#M101935
<P><LI-USER uid="1067610"></LI-USER> </P>
<P>As a comment, why don't to calculate Time in Between as</P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 711px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/285328iE7613621AC7C8C0B/image-size/large?v=v2&px=999" role="button" title="image.png" alt="image.png" /></span></P>
<P>or</P>
<P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 609px;"><img src="https://techcommunity.microsoft.com/t5/image/serverpage/image-id/285329i6143FC1843682D83/image-size/large?v=v2&px=999" role="button" title="image.png" alt="image.png" /></span></P>Tue, 01 Jun 2021 14:22:43 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2404200#M101935Sergei Baklan2021-06-01T14:22:43ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2407624#M102024
Thanks! this is what I had forgotten. (I haven't used excel for several years)Wed, 02 Jun 2021 10:32:17 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2407624#M102024eingram252021-06-02T10:32:17ZRe: Calculating values in a row
https://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2407663#M102026
Thank you very much! I will try it. I/m going to start a new sheet by copying and transposing as you suggestedWed, 02 Jun 2021 10:40:12 GMThttps://techcommunity.microsoft.com/t5/excel/calculating-values-in-a-row/m-p/2407663#M102026eingram252021-06-02T10:40:12Z