• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 61
  • Last Modified:

Excel Formula

trying to get the average number ignoring all negative value, data and is in one workbook and the info should be in another.
0
Jorge Ocampo
Asked:
Jorge Ocampo
  • 3
  • 3
1 Solution
 
Ryan ChongCommented:
try use AVERAGEIF or AVERAGEIFS functions:

example:
=AVERAGEIF(D2:D12,">0",D2:D12)

Open in new window

try change the range accordingly.

more info:

How to calculate average in Excel - formula examples of AVERAGE, AVERAGEIF, AVERAGEIFS
https://www.ablebits.com/office-addins-blog/2015/08/28/excel-average-averageif/
0
 
Rgonzo1971Commented:
Hi,

since the question does not exclude 0s

then try
=AVERAGEIF(D2:D12,">=0",D2:D12)

Open in new window

Regards
0
 
Jorge OcampoAuthor Commented:
that part i got but what about getting the info from a different sheet for example data is in sheet1 but i am trying to display data in sheet2?
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

 
Rgonzo1971Commented:
then try in sheet2

=AVERAGEIF(Sheet1!D2:D12,">=0",Sheet1!D2:D12)
0
 
Jorge OcampoAuthor Commented:
so it avoids any negative numbers?
0
 
Jorge OcampoAuthor Commented:
i had to do this ">0" since this ">=0 gave me wrong information
0
 
Rgonzo1971Commented:
Your choice
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now