Less than greater than

[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)

 

[JP Ronse]

Hi Jim,

Try ...

=AVERAGE(IF((T1:T10<=-110)*(T1:T10>=-180);T1:T10))

Wkr,

JP

 

[JimS]

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.

 

[Pete_UK]

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

 

[JimS]

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

 

[Pete_UK]

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 -

 

[JP Ronse]

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

 

[Pete_UK]

That's okay, JP - we're all here to help one another.

Pete