ColumnA Column B ColumnC ColumnE Column F Column G
Client name Sale $2,958.73 Kelly RSP
5-Feb-07
Client name Sale $91,000.00 Sherri Non-Reg 12-Feb-07
Client name Sale $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 E (salespeople names) 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 it
automatically adds $2958.73 AND $15,648.47 to her total quarterly sales below
in c67:

Column A (row 66) Column B (row 66) Column C (row 66)
Kelly
$18607.20 (ROW 67)


This is the formula I put in row 67 Column C to make it calculate the
quarterly sales total ($18607.20) but it does not work.

a67 is where Kelly's name appears
c67 is where I want the running total of sales for Kelly for Q1
e2:e64 = list of who made sales
c2:c64 = sales made per salesperson

=sumproduct(--(e2:e64=a67),--(year(g2:g64)=2007)*(month(g2:g64)<=3),c2:c64)

What do you mean when you say it doesn't work? Does it give errors?
the wrong value? no value?

You should ensure that there are no leading or trailing spaces around
the names in column E and in A67. Also ensure that the amounts in
column C are numbers, and not text values that look like numbers -
what do you see in the formula bar when you select a cell in column C?

Hope this helps.

Pete

On Nov 12, 10:17 pm, cdw wrote:
ColumnA Column B ColumnC ColumnE Column F Column G
Client name Sale $2,958.73 Kelly RSP
5-Feb-07
Client name Sale $91,000.00 Sherri Non-Reg 12-Feb-07
Client name Sale $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 E (salespeople names) 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 it
automatically adds $2958.73 AND $15,648.47 to her total quarterly sales below
in c67:

Column A (row 66) Column B (row 66) Column C (row 66)
Kelly
$18607.20 (ROW 67)

This is the formula I put in row 67 Column C to make it calculate the
quarterly sales total ($18607.20) but it does not work.

a67 is where Kelly's name appears
c67 is where I want the running total of sales for Kelly for Q1
e2:e64 = list of who made sales
c2:c64 = sales made per salesperson

=sumproduct(--(e2:e64=a67),--(year(g2:g64)=2007)*(month(g2:g64)<=3),c2:c64)

It pays to stick to your original thread from yesterday.

Exactly what doesn't work?

Wrong answer - no answer - error message?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"cdw" wrote in message
...
ColumnA Column B ColumnC ColumnE Column F Column G
Client name Sale $2,958.73 Kelly RSP
5-Feb-07
Client name Sale $91,000.00 Sherri Non-Reg
12-Feb-07
Client name Sale $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 E (salespeople names) 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 it
automatically adds $2958.73 AND $15,648.47 to her total quarterly sales
below
in c67:

Column A (row 66) Column B (row 66) Column C (row 66)
Kelly
$18607.20 (ROW 67)


This is the formula I put in row 67 Column C to make it calculate the
quarterly sales total ($18607.20) but it does not work.

a67 is where Kelly's name appears
c67 is where I want the running total of sales for Kelly for Q1
e2:e64 = list of who made sales
c2:c64 = sales made per salesperson

=sumproduct(--(e2:e64=a67),--(year(g2:g64)=2007)*(month(g2:g64)<=3),c2:c64)