Countif not blank

I would like to count a the number of cells in a range that are not blank.
=countif(a1:a14,"<>""") includes blank cells in its results.

I checked to see if the cells were actually blank by using
=countif(a1:a14,""),which counted the blank cells correctly.

Anybody got any ideas?

Thanks

=COUNTA(A1:A14)

Vaya con Dios,
Chuck, CABGx3




"Darby" wrote:

> I would like to count a the number of cells in a range that are not blank.
> =countif(a1:a14,"<>""") includes blank cells in its results.
>
> I checked to see if the cells were actually blank by using
> =countif(a1:a14,""),which counted the blank cells correctly.
>
> Anybody got any ideas?
>
> Thanks

You're close:

=COUNTIF(A1:A14,"<>"&"")

--
Regards,
Dave


"Darby" wrote:

> I would like to count a the number of cells in a range that are not blank.
> =countif(a1:a14,"<>""") includes blank cells in its results.
>
> I checked to see if the cells were actually blank by using
> =countif(a1:a14,""),which counted the blank cells correctly.
>
> Anybody got any ideas?
>
> Thanks

Thanks, works like a charm

"David Billigmeier" wrote:

> You're close:
>
> =COUNTIF(A1:A14,"<>"&"")
>
> --
> Regards,
> Dave
>
>
> "Darby" wrote:
>
> > I would like to count a the number of cells in a range that are not blank.
> > =countif(a1:a14,"<>""") includes blank cells in its results.
> >
> > I checked to see if the cells were actually blank by using
> > =countif(a1:a14,""),which counted the blank cells correctly.
> >
> > Anybody got any ideas?
> >
> > Thanks