Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(Column = Today, Countif, NA()) Help
Hey All,
Hope you are doing well... Getting right to the point... =IF(LOOKUP(TODAY(),ManualData!I:I),COUNTIF(INDIREC T(ManualData!G:G"),"*"&A2),NA()) It is still counting the whole column even if it is not todays date, what am I doing wrong? If you need more information, just let me know. Any help would be great! Thanks in advanced!!!!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF for numbers of dates in column which are 30 days older than today | Excel Worksheet Functions | |||
Countif date before today | Excel Discussion (Misc queries) | |||
excel today countif over expired date | Excel Worksheet Functions | |||
countif a date is greater than today | Excel Worksheet Functions | |||
countif(a1:a12,">TODAY()") How do I get this to work? | Excel Worksheet Functions |