Counting

[Kris]

I am looking for a way to count dates in a range of cells and have Excel
calculate how many cells have a value that is not equal to 0.

Basically what I want to count is how many in the cell range have a date
entered and are not showing zero. I have a formula in each cell that is
using VLOOKUP to pull info from another report that shows a date a report was
approved. Since I changed the column to be a date field, all cells that are
zero show 01/0/00 instead of false or 0.

How can I do this?

 

[Jacob Skaria]

Try

=COUNTIF(A:A,">0")

If this post helps click Yes

 

[Kris]

It worked, I thought I tried this, but apparently not!
Thanks