Forum Discussion
Calculating values in a row
I need to calculate the average values in a row and it is to be updated daily.
I need to always use the same start cell, but the value will change with each new days value.
Change B3 to $B3 in the formula. This will "fix" the column letter B.
9 Replies
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.
You might use a formula such as =AVERAGE(D2:ZZ2) since AVERAGE ignores empty cells.
- 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.
See the spreadsheet I attached to mathetes answer.Change B3 to $B3 in the formula. This will "fix" the column letter B.
