Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
help on AVERAGEIF formula
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="URkidding" data-source="post: 1676436" data-attributes="member: 361098"><p>I have a column of data that contains numbers from 0-500.</p><p></p><p>I would like to average the values of all numbers that fall between 60 and 242</p><p></p><p>I can average the numbers greater than 60 averageif(P2<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue :p" loading="lazy" data-shortname=":p" />262, >60, P2<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick out tongue :p" loading="lazy" data-shortname=":p" />262)</p><p></p><p>and the same for less than 242</p><p></p><p>I don't see how to include both <> in the same operation.</p></blockquote><p></p>
[QUOTE="URkidding, post: 1676436, member: 361098"] I have a column of data that contains numbers from 0-500. I would like to average the values of all numbers that fall between 60 and 242 I can average the numbers greater than 60 averageif(P2:P262, >60, P2:P262) and the same for less than 242 I don't see how to include both <> in the same operation. [/QUOTE]
Verification
Name this item 🌈
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
help on AVERAGEIF formula
Top
