LinkBack URL
About LinkBacks
Hi all!
I would like to take the average of a number of data points in a column based on boundaries applied to the column next to it. Sorry for the bad explanation. Please refer to the example to make it understandable:
example.xlsx
Cheers,
Hi all!
I would like to take the average of a number of data points in a column based on boundaries applied to the column next to it. Sorry for the bad explanation. Please refer to the example to make it understandable:
example.xlsx
Cheers,
Something like =AVERAGE(INDEX($B$1:$B$16,D1):INDEX($B$1:$B$16,D2)) ?
I'm going to check that out. Thanks already!
Thanks it works exactly as I meant!Nice!.jpg
hi Kybynn, try this as an alternative:
=AVERAGE(INDIRECT("B"&D1&":B"&D2))
Pepe's solution is less volatile though
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
example.xlsxPepe's example wasn't exactly what I meant, therefore I created a new example wherein it is explained better...
=average(index($b$1:$b$16,d1):index($b$1:$b$16,d2-1))
The boundaries in E5 are totally different from the preceding patterns???
Heya guys,
Thanks for the replies, but this is not exactly what I'm looking for.
example.xlsx
I tried to explain it better in the example. The idea is to apply the stated boundaries in column D to column A and based on these, retreive the average from column B. Instead of taking the xth row from column B.
"i.e. for the blue range range only use the values in column B
when the values in column A are = 11≤x≤15"
But in your example the rows from 12 to 16 are blue and your average is calculated on the same range?????
Yes because row 12 to 16 of column A are within the specified requirements of 11≤x≤15 i.e. the values of column A of row 12 to 16 (11.2, 11.9, 12, 13.8 and 14.3) are equal to or bigger than 11 and are smaller or equal to 15. Therefore the average is taken of row 12 to row 16 of column B.
This is exactly what I am trying to do. By the way, sorry that this wasn't clear immediately.
Cheers or salut or dag!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks