If(Column = Today, Countif, NA()) Help

  • Thread starter Thread starter KS
  • Start date Start date
K

KS

Hey All,

Hope you are doing well...

Getting right to the point...

=IF(LOOKUP(TODAY(),ManualData!I:I),COUNTIF(INDIRECT(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!!!!!
 
=IF(LOOKUP(TODAY(),ManualData!I:I),COUNTIF(INDIRECT(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(INDIRECT("ManualData!G:G"),"*"&A2),NA())
 
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("ManualData!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("ManualData!H:H")=1))

Hope this helps.

Peggy
 
Back
Top