Solved Excel: i want to program an average around a changeable peak

Microsoft Excel 2010
September 10, 2012 at 07:27:30
Specs: Windows 7
 Hello.I am new in programming with excel, and so i struggle with programing cells.The Case:I have different pumps which provided different performances when tested. and now i have loads of data to analyse.f.e. i have the columns "efficiency"(D33:D39) and "flow" (B33:B39)"flow" has its peak at the last entry"efficiency" has its peak somewhere in the middlewhat i need is:find the maximum value(BEP) in "efficiency" and take an average over all entries in the range of 0,7*Flow(at BEP) to 1,3*Flow(at BEP) what i tried: =AVERAGEIF(D33:D39;"< 1,3*I33 AND >0,7*I33";B33:B39)I33 =MAX(D33:D39)It didnt work because the criteria didnt have the right format.he neither accepted "< (1,3*60)" nor " < (I33*1,3)" he just accepted "<80" or I33So, how can i do such a complexe ;) calculation on excel? respectively. how can i adjust the cirteria so Excel finds the requested peak and its range itself?Thank you for help!

See More: Excel: i want to program an average around a changeable peak

#1
September 10, 2012 at 08:24:57