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

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)
> >
> >
> >