View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KS KS is offline
external usenet poster
 
Posts: 33
Default 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!!!!!