how do you not include 0's when working out averages in a huge set of data
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" <[email protected]> wrote in
message news:[email protected]...
>
> 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" <[email protected]> wrote in message
news:[email protected]...
> Enter the formula:
> =AVERAGE(IF(A1:A100=0,"",A1:A100))
> press control shift enter
>
> Mangesh
>
>
> "maksud" <[email protected]> wrote in
> message news:[email protected]...
> >
> > 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
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks