ExcelBanter - averaging from one selected cell to another

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - averaging from one selected cell to another (https://www.excelbanter.com/excel-discussion-misc-queries/3139-averaging-one-selected-cell-another.html)

anthonysuccar

averaging from one selected cell to another

I have a table with x and y values. I have another z column. In the z column
i want to be able to average between the x value along that row location to
the cell that has a value below a certain number say 4y.

All times are GMT +1. The time now is 04:21 PM.