Hi Excel Forum!
I have a challenge that I hope someone here can solve.
I am trying to calculate an Average only if an adjacent cell falls within a Range.
In D16, the Average of the values in E2:E12 is needed, only if the values within B2:B12 falls within the interval expressed in Cell A16, same for A17 until A25.
I am attaching an spreadsheet to give a clearer picture.
Thanks in advance!!
challenge.xlsx
Bookmarks