Since the cell is empty, it won't be included in the =countif() and it won't be
included in the =count().
In fact, all nonnumeric entries would be excluded from the =count() portion.
Am I missing something?
Glenda wrote:
>
> 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
> >

Dave Peterson
