Sum within a date range meeting one other criteria
 

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.

Sum within a date range meeting one other criteria
 

Try this:

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

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

Biff

wrote in message
ups.com...
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.

Sum within a date range meeting one other criteria
 

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

On Jan 27, 10:15 pm, "T. Valko" wrote:
Try this:

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

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

Biff

wrote in oglegroups.com...



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.- Hide quoted text -- Show quoted text -

Sum within a date range meeting one other criteria
 

You're welcome. Thanks for the feedback!

Biff

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

On Jan 27, 10:15 pm, "T. Valko" wrote:
Try this:

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

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

Biff

wrote in
oglegroups.com...



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.- Hide quoted text -- Show quoted text -