+ Reply to Thread
Results 1 to 3 of 3

not including 0's

  1. #1
    Registered User
    Join Date
    08-09-2005
    Posts
    2

    not including 0's

    how do you not include 0's when working out averages in a huge set of data

  2. #2
    Mangesh Yadav
    Guest

    Re: not including 0's

    Enter the formula:
    =AVERAGE(IF(A1:A100=0,"",A1:A100))
    press control shift enter

    Mangesh


    "maksud" <maksud.1thrqu_1123581952.7997@excelforum-nospam.com> wrote in
    message news:maksud.1thrqu_1123581952.7997@excelforum-nospam.com...
    >
    > how do you not include 0's when working out averages in a huge set of
    > data
    >
    >
    > --
    > maksud
    > ------------------------------------------------------------------------
    > maksud's Profile:

    http://www.excelforum.com/member.php...o&userid=26083
    > View this thread: http://www.excelforum.com/showthread...hreadid=394150
    >




  3. #3
    Bob Phillips
    Guest

    Re: not including 0's

    Don't even need the other result

    =AVERAGE(IF(A1:A100<>0,A1:A100))

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Mangesh Yadav" <mangesh.NOSPAMyadav@gmail.com> wrote in message
    news:eF31c0MnFHA.2180@TK2MSFTNGP15.phx.gbl...
    > Enter the formula:
    > =AVERAGE(IF(A1:A100=0,"",A1:A100))
    > press control shift enter
    >
    > Mangesh
    >
    >
    > "maksud" <maksud.1thrqu_1123581952.7997@excelforum-nospam.com> wrote in
    > message news:maksud.1thrqu_1123581952.7997@excelforum-nospam.com...
    > >
    > > how do you not include 0's when working out averages in a huge set of
    > > data
    > >
    > >
    > > --
    > > maksud
    > > ------------------------------------------------------------------------
    > > maksud's Profile:

    > http://www.excelforum.com/member.php...o&userid=26083
    > > View this thread:

    http://www.excelforum.com/showthread...hreadid=394150
    > >

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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