Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Hello Clément, insert rows between A1 and A5 (not below A5) and watch how the formula =AVERAGE(A1:A5) increases insert by insert. Say you insert 4 rows and it will show you =AVERAGE(A1:A9). If it is a difference in your use case to insert rows above instead of below, please explain why. Average would calculate anyway, no matter where you insert rows and which order of the numbers but the 'automatic' update of the formula would not work, if you insert below your range.