sum values if date matches a condition

Originally Posted by L-Drr

Something like this:

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

maybe my semicolon should be a comma for you

thank, but it works only if date matches TODAY, not before or after today, that is what I need
if I write
SUMIFS(C1:C5;A1:A5;>TODAY();B1:B5;"alan") I get a message of mistake

thanks all