I'm trying to make a spreadsheet that displays the average of a row, i.e.
=average(c3:al3) and the function is in column AN3.
I want to copy that function down a row (but need to do this for 560 rows) and I need it to auto change from C3:AL3 to C4:AL4 (if this makes sense). I know I can do it by hand but that would be prohibitively time consuming. I can insert a row into a column wide formula (such as
=average(c3:c560) and it will auto change it to
=average(c3:561)) just want to know if can do the same or do it as a bulk action for rows.