Thread: not including 0's

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

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
>

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
> >
>
>