CODEWITHSUNDEEP
excel
yithril
yithril

Reputation: 67

Using Countif with two parameters

I wish to count the number of dates in a given column. The column has three possible values for a cell. A cell can be blank, have an "x", or have a date. I don't care what the actual date is, I just want to count the number of cells that have a date in them.

Upvotes: 1

Views: 158

Answers (2)

zx8754
zx8754

Reputation: 56189

Using COUNT, it counts only if the cell value is numeric. The dates are internally numeric.

=COUNT(A:A)

enter image description here

Upvotes: 2

Scott Craner
Scott Craner

Reputation: 152525

Use COUNTIFS()

=COUNTIFS(A:A,">=" & DATE(1900,1,1),A:A,"<=" & DATE(2045,12,31))

You can bracket the dates to what ever you want.

enter image description here

OR

You can do the negative.

If you are possitive the only three values possible are blank,x, and a date then:

=COUNTIFS(A:A,"<>",A:A,"<>x")

Upvotes: 2

Related Questions