Hi,

I thought I had this working before, but now it's not. In my column, "# of Tasks
Due This Week" is suppose to be same principle as my previous question, except now I'm seeking total number of tasks within a specified week for an individual through:

=IF(G48="","",SUMPRODUCT(--('T1 Task Log'!$Q$13:$Q$570>=I48),--('T1 Task Log'!$Q$13:$Q$570<=J48),--(ISNUMBER(SEARCH(G48,'T1 Task Log'!$O$13:$O$570)))))

It's not adding up correctly or at all, depending on how I modify the function. As before, there may be multiple task owners & I'm seeking the individual defined in cell G48.

Any suggestions?

Thanks