Hi,
I have a range of data from a dyno tune of electric motors for RC racing. I have a column of rpm and power out. The rpm were marked with different points of data (e.g. 3755, 7654, 9945, etc) and gives out total power out (W). I am trying to get the average power out (W) from a specific range of data from the RPM, say for example, from 5k - 10k. The formula I had was below:
=AVERAGEIF(C2:C184,5000<=10000,E2:E184)
It did not work and gave me the =DIV/0
Is there another way to do this?
Your formula syntax is incorrect.
Try this instead:
=AVERAGEIFS(E2:E184,C2:C184,">="&5000,C2:C184,"<=10000")
If there was nothing under row 184 (that shouldn't be considered in the formula) you could use whole column references without a (noticeable) performance decrease to make it a little shorter:
=AVERAGEIFS(E:E,C:C,">="&5000,C:C,"<=10000")
Last edited by 63falcondude; 06-03-2017 at 10:02 AM.
That's actually TWO tests, >=5000 and <=10000, they are handled separately.
=AVERAGEIFS($E$2:$E$184,$C$2:$C$184,">="&C186,$C$2:$C$184,"<="&D186)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Falcondude, it was giving me an error saying it doesn't recognize the formula. Hard to explain. EDIT: sorry, I just realize what you said if there was nothing under row 184. I will try that again.
However, Jbeaucaire, it worked. I'm trying to understand why all the $? Is there a way you can explain the reason for it? Is it just so it only grabs the data from that range?
I should solve this with a helpcolumn and VLookup.
After that a pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
That was super fast. I still haven't learned how to do pivot tables or Vlookup. Should I get a book for it or is there something online you guys recommend?
I learned it the hard way, (work much with excel) and learn from others (other questions).
for info. The $ signs lock cell references.
=$A1 copied across will return the value in A1, but will return the value in A2, A3, etc when copied down
=A$1 copied down will return the value in A1, but will return the value in B1, C1, etc when copied across
=$A$1 will return the value in A1, irrespective of the direction in which it is copied
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Am I missing something in this formula? I'm trying to use another sheet in the workbook.
=AVERAGEIFS('30 Degrees'!$E$2:$E$184,'30 Degrees'!$C$2:$C$184,">="&'30 Degrees'!C186,'30 Degrees'!$C$2:$C$184,"<="&'30Degrees'!D186)
What is the problem?
=AVERAGEIFS('30 Degrees'!$E$2:$E$184,'30 Degrees'!$C$2:$C$184,">="&'30 Degrees'!C186,'30 Degrees'!$C$2:$C$184,"<="&'30 Degrees'!D186)
space missing in posted formula but assume that is just a typo.
Please smack me across the face lol. That solved it.Originally Posted by JohnTopley
Easily done!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks