Sum within a date range meeting one other criteria

[Doc203]

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) 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.

 

[T. Valko]

Try this:

=SUMPRODUCT(--(C1:C100<=TODAY()-14),--(B1:B100="Joe"),D1100)

Note: you can't use entire columns as range references with Sumproduct
unless you're using Excel 2007.

Biff

 

[Doc203]

Biff, that was right on the money! I also did not know about using
entire colums as a refence. Thanks for the help!

 

[T. Valko]

You're welcome. Thanks for the feedback!

Biff

Biff, that was right on the money! I also did not know about using
entire colums as a refence. Thanks for the help!