Counting
 

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?

Counting
 

Try

=COUNTIF(A:A,"0")

If this post helps click Yes
---------------
Jacob Skaria


"Kris" wrote:

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?

Counting
 

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

"Jacob Skaria" wrote:

Try

=COUNTIF(A:A,"0")

If this post helps click Yes
---------------
Jacob Skaria


"Kris" wrote:

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?