| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count if cell value
I am trying to use the folowing formula =COUNTIF(C2:C7,"8-19-09"). It works
however, I would like to change the criteria to either today() or have it look a specific cell where I can change the date. When I try it the value goes to 0. Thanks for your time. Clark |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if cell value
Try it like this:
A1 = some date =COUNTIF(C2:C7,""&A1) -- Biff Microsoft Excel MVP "Clark Tidwell" <Clark wrote in message ... I am trying to use the folowing formula =COUNTIF(C2:C7,"8-19-09"). It works however, I would like to change the criteria to either today() or have it look a specific cell where I can change the date. When I try it the value goes to 0. Thanks for your time. Clark |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count if cell value
To always compare to today(), try
=COUNTIF(C2:C7,""&TODAY()) To compare to a date in another cell (for example, G1), try =COUNTIF(C2:C7,""&G1) Hope this helps, Hutch "Clark Tidwell" wrote: I am trying to use the folowing formula =COUNTIF(C2:C7,"8-19-09"). It works however, I would like to change the criteria to either today() or have it look a specific cell where I can change the date. When I try it the value goes to 0. Thanks for your time. Clark |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count if the cell contains a word found in another cell | Excel Worksheet Functions | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| How to auto count data in an empty cell to be 0. Blank cell=0 | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
Linear Mode
