ColumnA Column B ColumnC Column E Column G
Client Name Sale $2,958.73 Kelly 5-Feb-07
Client Name Sale $15,648.47 Kelly 7-Mar-07
Client Name Sale $15,444.00 Carrie 5-Jan-07
These are my columns. I want to make a running total for each salesperson
PER QUARTER. So if their name appears in Column E AND Jan, Feb or Mar
appears in Column G, I want it to add their sales numbers from Column C to
this quarterly total:

Ex) Kelly appeared in Col E AND Feb appeared in Column G so I want it to add
$2958.73 AND $15,648.47 to her total quarterly sales total in (Column C,
row67):

Column A Column C (row 66)
Kelly (C67 -need formula?????)

This is the formula I used and it keeps telling me that there is a problem:
I am inputting this formula into cell c67:
=sumproduct((e2:e64=a67)*(g2:g64=J9)*(g2:g64<=j10 ),c2:c64)
a67 is where Kelly's name appears (as well as several times in Column E)
c67 is where I want the running total of sales for Kelly for Q1
j9 = 01-Jan-07 (begin of quarter)
j10 = 31-Mar-07 (end of quarter)
e2:e64 = list of who made sales
c2:c64 = sales made

This is the formula I used and it keeps telling me that there is a problem:
=sumproduct((e2:e64=a67)*(g2:g64=J9)*(g2:g64<=j1 0),c2:c64)

Works just fine for me. Screencap:

http://img75.imageshack.us/img75/6554/sumphf9.jpg

it keeps telling me that there is a problem

What problem?


--
Biff
Microsoft Excel MVP


"cdw" wrote in message
...
ColumnA Column B ColumnC Column E Column G
Client Name Sale $2,958.73 Kelly 5-Feb-07
Client Name Sale $15,648.47 Kelly 7-Mar-07
Client Name Sale $15,444.00 Carrie 5-Jan-07
These are my columns. I want to make a running total for each salesperson
PER QUARTER. So if their name appears in Column E AND Jan, Feb or Mar
appears in Column G, I want it to add their sales numbers from Column C to
this quarterly total:

Ex) Kelly appeared in Col E AND Feb appeared in Column G so I want it to
add
$2958.73 AND $15,648.47 to her total quarterly sales total in (Column C,
row67):

Column A Column C (row 66)
Kelly (C67 -need formula?????)

This is the formula I used and it keeps telling me that there is a
problem:
I am inputting this formula into cell c67:
=sumproduct((e2:e64=a67)*(g2:g64=J9)*(g2:g64<=j10 ),c2:c64)
a67 is where Kelly's name appears (as well as several times in Column E)
c67 is where I want the running total of sales for Kelly for Q1
j9 = 01-Jan-07 (begin of quarter)
j10 = 31-Mar-07 (end of quarter)
e2:e64 = list of who made sales
c2:c64 = sales made

Third post on same subject.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cdw" wrote in message
...
ColumnA Column B ColumnC Column E Column G
Client Name Sale $2,958.73 Kelly 5-Feb-07
Client Name Sale $15,648.47 Kelly 7-Mar-07
Client Name Sale $15,444.00 Carrie 5-Jan-07
These are my columns. I want to make a running total for each salesperson
PER QUARTER. So if their name appears in Column E AND Jan, Feb or Mar
appears in Column G, I want it to add their sales numbers from Column C to
this quarterly total:

Ex) Kelly appeared in Col E AND Feb appeared in Column G so I want it to
add
$2958.73 AND $15,648.47 to her total quarterly sales total in (Column C,
row67):

Column A Column C (row 66)
Kelly (C67 -need formula?????)

This is the formula I used and it keeps telling me that there is a
problem:
I am inputting this formula into cell c67:
=sumproduct((e2:e64=a67)*(g2:g64=J9)*(g2:g64<=j10 ),c2:c64)
a67 is where Kelly's name appears (as well as several times in Column E)
c67 is where I want the running total of sales for Kelly for Q1
j9 = 01-Jan-07 (begin of quarter)
j10 = 31-Mar-07 (end of quarter)
e2:e64 = list of who made sales
c2:c64 = sales made