Sumproduct Help PLEASE
 

ColumnA Column B ColumnC ColumnD
$2,958.73 Kelly RSP 5-Feb-07
$91,000.00 Sherri Non-Reg 12-Feb-07
$15,648.47 Kelly RRIF 21-Mar-07
These are my columns. I want to make a running total for each salesperson
PER QUARTER. So if their name appears in Column B AND Jan, Feb or Mar
appears in Column D, I want it to add their sales numbers from Column A to
this quarterly total:

Ex) Kelly appeared in Col B AND Feb appeared in Column D so it added
$2958.73 to her total quarterly sales:

Kelly 1st Quarter Sales $18607.2 (total sales for Jan,Feb,Mar)

Sumproduct Help PLEASE
 

Hi,

Maybe

=SUMPRODUCT((B2:B100=E1)*(D2:D100=F1)*(D2:D100<=G 1)*A2:A100)

Where
E1 = Name to find
F1 = Quarter start date
G1 = Quarter end date

Mike

"cdw" wrote:

ColumnA Column B ColumnC ColumnD
$2,958.73 Kelly RSP 5-Feb-07
$91,000.00 Sherri Non-Reg 12-Feb-07
$15,648.47 Kelly RRIF 21-Mar-07
These are my columns. I want to make a running total for each salesperson
PER QUARTER. So if their name appears in Column B AND Jan, Feb or Mar
appears in Column D, I want it to add their sales numbers from Column A to
this quarterly total:

Ex) Kelly appeared in Col B AND Feb appeared in Column D so it added
$2958.73 to her total quarterly sales:

Kelly 1st Quarter Sales $18607.2 (total sales for Jan,Feb,Mar)