Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Red face Unanswered: a problem of average formula

    I'm facing a problem about average formula that I can not solve at the moment but I know it's quite simple for you.
    My excel table is as follow:
    a1 b1 c1 d1 e1 f1
    0 3 2 0 5 =average(a1:e1)

    the problem is I want to average only cells that is greater than 0 (the result must be 3.33, not 2)

    Could anyone help me to solve above problem
    thanks in advanced.

  2. #2
    Join Date
    Oct 2003
    If only positive numbers and zero will be entered, then use this:


    If negative numbers can also be used, then use this:

    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    May 2004
    it works for me. thank you very much

Posting Permissions

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