View Single Post
  #1   Report Post  
CiCi Bird
 
Posts: n/a
Default 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)