In COUNTIF function, how do I count the number of cells which con.

I have one column of over 100 cells that are either blank or contain a date.
If I use the following, it doesn't add them up correctly.
=COUNTIF(G2:G113,"*") or
=COUNT(G2:G113)

You don't say what you want to count but I guess dates. Dates are values,
and count counts values, so maybe your dates are not values? Or your "blank"
cells contain some numbers and are hidden by conditional formatting?



"CiCi Bird" <CiCi Bird@discussions.microsoft.com> wrote in message
news:89D196AD-DEE2-46BB-B0AC-81BB736B55C3@microsoft.com...
> I have one column of over 100 cells that are either blank or contain a
date.
> If I use the following, it doesn't add them up correctly.
> =COUNTIF(G2:G113,"*") or
> =COUNT(G2:G113)

Hi Dave R.
I am counting the number of cells that contain a date (01/01/05 for
example), but each cell contains a different date. All other cells are blank
with no conditional formatting other than each cell is formatted for a
"date". Does this provide the info you need? Thanks so much! CiCi

"Dave R." wrote:

> You don't say what you want to count but I guess dates. Dates are values,
> and count counts values, so maybe your dates are not values? Or your "blank"
> cells contain some numbers and are hidden by conditional formatting?
>
>
>
> "CiCi Bird" <CiCi Bird@discussions.microsoft.com> wrote in message
> news:89D196AD-DEE2-46BB-B0AC-81BB736B55C3@microsoft.com...
> > I have one column of over 100 cells that are either blank or contain a
> date.
> > If I use the following, it doesn't add them up correctly.
> > =COUNTIF(G2:G113,"*") or
> > =COUNT(G2:G113)
>
>
>

=COUNT(G2:G113)

will count all numeric values and since you only have dates or blanks and
excel dates are numbers it should tell you how many dates

=COUNTBLANK(G2:G113)

count blank cells and

ROWS(G2:G113)

count rows thus cells


Regards,

Peo Sjoblom

"CiCi Bird" wrote:

> Hi Dave R.
> I am counting the number of cells that contain a date (01/01/05 for
> example), but each cell contains a different date. All other cells are blank
> with no conditional formatting other than each cell is formatted for a
> "date". Does this provide the info you need? Thanks so much! CiCi
>
> "Dave R." wrote:
>
> > You don't say what you want to count but I guess dates. Dates are values,
> > and count counts values, so maybe your dates are not values? Or your "blank"
> > cells contain some numbers and are hidden by conditional formatting?
> >
> >
> >
> > "CiCi Bird" <CiCi Bird@discussions.microsoft.com> wrote in message
> > news:89D196AD-DEE2-46BB-B0AC-81BB736B55C3@microsoft.com...
> > > I have one column of over 100 cells that are either blank or contain a
> > date.
> > > If I use the following, it doesn't add them up correctly.
> > > =COUNTIF(G2:G113,"*") or
> > > =COUNT(G2:G113)
> >
> >
> >

My only guess is that some of your dates are actually text, and not values.

Here's a formula which will count both text dates and dates.. if this works
you should probably check over your cells for text dates.

=SUMPRODUCT(--ISNUMBER(DATEVALUE(A1:A10)))+COUNT(A1:A10)



"CiCi Bird" <CiCiBird@discussions.microsoft.com> wrote in message
news:098859FE-6F6E-462B-BA14-7745B086096F@microsoft.com...
> Hi Dave R.
> I am counting the number of cells that contain a date (01/01/05 for
> example), but each cell contains a different date. All other cells are
blank
> with no conditional formatting other than each cell is formatted for a
> "date". Does this provide the info you need? Thanks so much! CiCi
>
> "Dave R." wrote:
>
> > You don't say what you want to count but I guess dates. Dates are
values,
> > and count counts values, so maybe your dates are not values? Or your
"blank"
> > cells contain some numbers and are hidden by conditional formatting?
> >
> >
> >
> > "CiCi Bird" <CiCi Bird@discussions.microsoft.com> wrote in message
> > news:89D196AD-DEE2-46BB-B0AC-81BB736B55C3@microsoft.com...
> > > I have one column of over 100 cells that are either blank or contain a
> > date.
> > > If I use the following, it doesn't add them up correctly.
> > > =COUNTIF(G2:G113,"*") or
> > > =COUNT(G2:G113)
> >
> >
> >