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!!!!! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(Column = Today, Countif, NA()) Help
=IF(LOOKUP(TODAY(),ManualData!I:I),COUNTIF(INDIRE CT(ManualData!G:G"),"*"&A2),NA())
If all the dates in I:I are less than or equal to TODAY then the LOOKUP returns the *last* date from the range. The numeric value of that date causes the IF logical test to evaluate as TRUE thereby executing the the COUNTIF. Why are you using INDIRECT? You're missing a quote. Maybe this is what you're after: =IF(COUNTIF(ManualData!I:I,TODAY()),COUNTIF(INDIRE CT("ManualData!G:G"),"*"&A2),NA()) -- Biff Microsoft Excel MVP "KS" wrote in message ... 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!!!!! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If(Column = Today, Countif, NA()) Help
Hi KS,
The Countif allows using "*"&A2, unfortunately the multi condition worksheet functions are not as flexible. The following formula checks to see if the date is the same as today and that column G is equal to A2. =SUMPRODUCT((ManualData!I:I=TODAY())*(INDIRECT("Ma nualData!G:G")=A2)) If you need to count based on whether a part of a cell's contents is equal to another cell - then you will have to create a new column to test for that condition. H2=IF(ISERROR(FIND(A$2,G2,1))=FALSE,1,0) =SUMPRODUCT((ManualData!I:I=TODAY())*(INDIRECT("Ma nualData!H:H")=1)) Hope this helps. Peggy "KS" wrote: 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!!!!! |
Reply |
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 |