I am new in programming with excel, and so i struggle with programing cells.
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 middle
what 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)
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 I33
So, 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!