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

[Guest]

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)

 

[Dave R.]

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?

 

[Guest]

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

 

[Guest]

=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

 

[Dave R.]

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)