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

Say headers are in Row1, and data is in A2 to D100,
And the name of the person to find is entered in E2 (Kelly),
And the start date of the quarter in question is entered into E3 (1-Jan-07),
And the end date of the quarter is entered into E4 (31-Mar-07).

Then try this:

=SUMPRODUCT((B2:B100=E2)*(D2:D100=E3)*(D2:D100<=E 4)*A2:A100)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cdw" wrote in message
...
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