=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!!!!!