Average different cell ranges depending on the value of another cell

[Nothnless]

Hello, obviously this would be a simple average if formula but in this case I need to change the range to average based on the value of another cell. For example, if cell G9 = 2 then get the average of cells G13:G14 but if cell G9 = 3 then get the average of cells G13:G15. Can anyone help? Thanks!

 

[lrobbo314]

Welcome to the forum.

How about this?

=AVERAGE(INDIRECT("G13:G"&12+G9))

 

[Nothnless]

Oh wow! it works! Thanks a lot, I didn't know about the indirect function.

 

[lrobbo314]

Sweet, glad that it worked! The indirect function is a good one.