Percentage of 1s

[Ben]

I have a column that has 1s or 0s, 1 equals female, 0 equals male. I want to
know what percentage is female. Is there a function that would do that?

Thank you.

[Niek Otten]

=AVERAGE(A1:A10)

Format as %

--
Kind regards,

Niek Otten

"Ben" <[email protected]> wrote in message
news:[email protected]...
>I have a column that has 1s or 0s, 1 equals female, 0 equals male. I want
>to
> know what percentage is female. Is there a function that would do that?
>
> Thank you.

[R..VENKATARAMAN]

=COUNTIF(A10:A25,0)/COUNT(A10:A25)

data is in A10 to A25
format is as percentage


"Ben" <[email protected]> wrote in message
news:[email protected]...
>I have a column that has 1s or 0s, 1 equals female, 0 equals male. I want
>to
> know what percentage is female. Is there a function that would do that?
>
> Thank you.

[R..VENKATARAMAN]

sorry that gives perenage of males
for femaltes
=COUNTIF(A10:A25,1)/COUNT(A10:A25)
"Ben" <[email protected]> wrote in message
news:[email protected]...
>I have a column that has 1s or 0s, 1 equals female, 0 equals male. I want
>to
> know what percentage is female. Is there a function that would do that?
>
> Thank you.

[Gizmo63]

count the number of 1's and divide by the total number of 1's and 0's.

=countif(a:a,1)/(countif(a:a,1)+countif(a:a,0))

Making the second half a sum of specifically 1's and 0's allows subtotals
and other commentary to go in col A without confusing the formula.

hth

Giz

"Ben" wrote:

> I have a column that has 1s or 0s, 1 equals female, 0 equals male. I want to
> know what percentage is female. Is there a function that would do that?
>
> Thank you.