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