Hi,

I have a sumproduct function in which I'm trying find a name within a specified date range in my cell G48.

The intent of this function is to pull task owner or task owners & determine how many tasks assigned.

I thought this was the wildcard function / finder - Not sure what's this is called:

"*"&G48&"*"

Except, it's not working. How do I need to change my function so it if finds a specified name (in cell G48), regardless of if there's text before or after?


=IF(G48="","",SUMPRODUCT(--('T1 Task Log'!$R$13:$R$570<>'T1 Task Log'!$L$11),--(ISNUMBER(FIND("*"&G48&"*",'T1 Task Log'!$O$13:$O$570)))))

Thanks