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?
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?