Sum If? Help

C

cdw

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
 
R

Ragdyer

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<=E4)*A2:A100)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top