I thought maybe something like:

=COUNTIF(A1:A4,A1)/COUNTA(A1:A4)


"Glenda" wrote in message
...
Okay, now what If I want to exclude the blank cell in a3

"Dave Peterson" wrote:

=countif(a1:a4,1)/count(a1:a4)

=count() returns the number of numbers in the range.

Glenda wrote:

I am trying to get the percentage of 1's in a column excluding blank
cells

A B
1 1 0
2 1 1
3
4 0

I know the formula would be =countif(a1:a4,1) answer would be 2 but,
how do
I get the percent of the #1's with including blank cells.

--

Dave Peterson