+ Reply to Thread
Results 1 to 4 of 4

how do i get an average base on a value?

  1. #1
    Registered User
    Join Date
    05-20-2019
    Location
    philippines
    MS-Off Ver
    ms office 2019
    Posts
    2

    Smile how do i get an average base on a value?

    wew.PNG

    how do i get the average DURATION of those that have value as 0 in LINES.
    and how do i get the average duration for those that have values in lines?

    please help

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: how do i get an average base on a value?

    Hello and welcome to the forum.

    Try the AVERAGEIF function.

    Something like this:

    =AVERAGEIF(G:G,0,I:I)

    and

    =AVERAGEIF(G:G,">0",I:I)

  3. #3
    Registered User
    Join Date
    05-20-2019
    Location
    philippines
    MS-Off Ver
    ms office 2019
    Posts
    2

    Re: how do i get an average base on a value?

    Thank you so much sir it works so well

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: how do i get an average base on a value?

    You're welcome. Happy to help.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. sort and split - base as average
    By psnreddy.info in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-25-2016, 05:30 AM
  2. sort and split - base as average
    By psnreddy.info in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 08-11-2016, 07:07 AM
  3. How to use pivot to average base on criteria ???
    By coolasia in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-08-2016, 04:03 AM
  4. [SOLVED] average the list base on condtional
    By pedjvak in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2015, 03:53 AM
  5. [SOLVED] Finding the average of positive numbers base on the previous date
    By top00001 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-27-2015, 03:54 AM
  6. Compute Average base on different column
    By ray_bt in forum Excel General
    Replies: 2
    Last Post: 05-23-2010, 12:23 PM
  7. base - calculate a YTD average
    By superspurs in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2009, 06:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1