Forum Discussion
Solved
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.
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.
- Thanks! this is what I had forgotten. (I haven't used excel for several years)
