Results 1 to 3 of 3

Thread: average function

  1. #1

    average function



    Register for a FREE account, and/
    or Log in to avoid these ads!

    i have a collegue who want to calculate the average of a filtered list, as in only calculate the results from the filter not the whole column/row

  2. #2
    Seeker lvalnegri's Avatar
    Join Date
    Jan 2012
    Location
    London
    Posts
    11
    Articles
    0
    Quote Originally Posted by peteb View Post
    i have a collegue who want to calculate the average of a filtered list, as in only calculate the results from the filter not the whole column/row
    If you are on excel 2007 you can use AVERAGEIF(Range, Criteria, Average_range), where: Range is the group of cells the function is to search; Criteria determines whether the data in a cell is to be averaged or not; Average_range is the data range that is averaged if the first range meets the specified criteria (if this range is omitted, the first range is averaged instead). If your version is prior to 2007 you should use the ratio SUMIF(Range, Criteria, Sum_range)/COUNTIF(Range, Criteria).

  3. #3
    thanks i will try that btw working with office 2010

Posting Permissions

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