SUMPRODUCT with Today() and text criteria

This is my 1st post and glad to be part of forum

Im attempting to add number of dates within a column (B). I have 2 criteria: Today and person "William". Im using the following and return results is "0"

A: Name
B: Date
C: Type

=SUMPRODUCT(--(Data!$B$2:$B$3100=TODAY()),--(Data!$A$2:$A$3100="William"),--(Data!$B$2:$B$3100))

Once I get this working I would like to adjust for last 30days and look at Type (C) = New

Any suggestions and can send a sample data set. Anyway, any suggestions will be appreciated!