Something like this:

=SUMIFS(C1:C5;A1:A5;TODAY();B1:B5;"alan")

maybe my semicolon should be a comma for you