How to change the range of which to calculate an average?

[Waimea]

Hi,

I have a data validation dropdown in cell E151, depending on the value of this cell I want to calculate an average of a range of cells.

If the data validation list in empty I want to calculate the average of range H151:L151.

If the data validation list says "1", I want to calculate the average of range H151:K151.

The data validation in cell E151 could have values from 1 to 10. So if the value of the data validation list in 3 I would get the average of H151:M151?

 

[Waimea]

I got it working with your formula and CF. Thank you for your time and your code!

Edit: Marked the solution as the solution.

 

[KRice]

That's good to hear. I'm happy to help.