| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| Counting | Excel Discussion (Misc queries) | |||
| need help with counting... | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Linear Mode
