I have 3 Columns, DATE, SALES, SALESPERSON.

I want to write a formula that states: If the date is more than 2
weeks ago what is the total sales by salesperson?

I tried a few versions of SUMIF and could not seem to get it to work.

=SUMIF(C:C,"<="&TODAY()-7,D:D) returns the amount for all sales but I
cannot figure out how to add the other variable of salesperson to the
mix. Thanks for any help.