Less than greater than

  • Thread starter Thread starter JimS
  • Start date Start date
J

JimS

I want to average a column of negative numbers (there are blanks) such
that I find the average of all numbers between -110 and -180. ( So if
I have 300 numbers in my list and 40 of them are between -110 and
-180, I want the average of just those numbers.)

I'm confusing myself trying to solve this.

So far I have two formulas, but I'm not sure how to combine things.
In fact, I'm not even sure if these are right.

Thanks.

=AVERAGEIF(G23:G3000,">=-180",G23:G3000)

=AVERAGEIF(G23:G3001,"<=-130",G23:G3001)
 
Hi, thanks. What is supposed to be the symbol at the end before the
T1? It looks like a semi colon. I tried a comma, but that didn't
work either.
 
Jim,

use a comma there if that is what you normally use in formulae.

Bear in mind also that this is an array formula - you need to commit
it using the key combination of Ctrl-Shift-Enter rather than the usual
<enter>.

Hope this helps.

Pete
 
Thanks, Pete. I didn't know it was an array formula. That solved the
problem and it now works. Thanks to you both.
 
You're welcome, Jim.

Pete

Thanks, Pete.  I didn't know it was an array formula.  That solved the
problem and it now works.  Thanks to you both.






- Show quoted text -
Click to expand...
 
Hi Pete,

Thanks, I have to keep in mind to mention to replace ";" by "," and when it
is an array formula.

Wkr,

JP


Jim,

use a comma there if that is what you normally use in formulae.

Bear in mind also that this is an array formula - you need to commit
it using the key combination of Ctrl-Shift-Enter rather than the usual
<enter>.

Hope this helps.

Pete
 
Back
Top