Re: text formulas

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On Mon, 18 Jul 2005 07:06:07 -0700, Rus
<Rus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>I have "Y,N,&NA" in one column. In another column off to the right I am
>counting those inputs. A total is then calculating those Y(which formulate
>to be 100%) and N (which formulate to be 0%) and then averaging them.
>
>However, I don't want the NA to be part of the average. Meaning, if NA is
>input, then the count would be NA, instead of 0% (like the N). It throws off
>the average and I want it excluded from the avg calculation
>
>Any thoughts on how to get this to work??

For the percentage of Y:

=COUNTIF(A1:A100,"=Y")/COUNTIF(A1:A100,"<>NA")

For the percentage of N:

=COUNTIF(A1:A100,"=N")/COUNTIF(A1:A100,"<>NA")

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner
.

Relevant Pages

  • Re: text formulas
    ... "Mangus Pyke" wrote: ... >>counting those inputs. ... A total is then calculating those Y(which formulate ...
    (microsoft.public.excel.worksheet.functions)
  • Re: text formulas
    ... > Tim C ... >> counting those inputs. ... A total is then calculating those Y(which ...
    (microsoft.public.excel.worksheet.functions)
  • text formulas
    ... counting those inputs. ... A total is then calculating those Y(which formulate ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: text formulas
    ... Tim C ... > counting those inputs. ... A total is then calculating those Y(which ...
    (microsoft.public.excel.worksheet.functions)
  • Re: As the Crow flies.
    ... So you think you can calculate, without calculating? ... Congratulations on finding the fastest algorithm in the world for ... meaning "Primes below N"? ... "Evidence confirming an observation is ...
    (talk.origins)