Re: text formulas
- From: "Tim C" <timclainc@xxxxxxxxx>
- Date: Mon, 18 Jul 2005 16:29:37 -0700
Try:
=COUNTIF(A1:A100,"Y")/(COUNTIF(A1:A100,"Y")+COUNTIF(A1:A100,"N"))
Tim C
"Rus" <Rus@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:7E083AA7-A827-4369-B1BA-56E8EB953BA5@xxxxxxxxxxxxxxxx
>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??
.
- References:
- text formulas
- From: Rus
- text formulas
- Prev by Date: Re: Tab key movement Excel 2002
- Next by Date: Count if 2 conditions are true
- Previous by thread: Re: text formulas
- Next by thread: Re: text formulas
- Index(es):
Relevant Pages
|
