Re: text formulas
- From: "Tim C" <timclainc@xxxxxxxxx>
- Date: Mon, 18 Jul 2005 16:33:08 -0700
Or shorter:
=1/(1+COUNTIF(A1:A100,"N")/COUNTIF(A1:A100,"Y"))
Tim C
"Tim C" <timclainc@xxxxxxxxx> wrote:
> Try:
>
> =COUNTIF(A1:A100,"Y")/(COUNTIF(A1:A100,"Y")+COUNTIF(A1:A100,"N"))
>
> Tim C
> "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??
.
- Prev by Date: Count if 2 conditions are true
- Next by Date: Re: Count if 2 conditions are true
- Previous by thread: Re: text formulas
- Next by thread: trouble filtering a list. Why isn't column filtering?
- Index(es):
Relevant Pages
|
