Help with Sum Product - lots of posts before but none work!?!? PLE

C

cdw

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)
 
P

Pete_UK

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
 
R

RagDyer

It pays to stick to your original thread from yesterday.

Exactly what doesn't work?

Wrong answer - no answer - error message?
 

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