Assumptions:
Sheet2...
Column A contains true date values
Sheet1...
Column A, starting at A2, contains the customer
The first row, starting at B1, contains the month entered in the
following manner...
1/1/2005
1/2/2005
1/3/2005
....and custom formatted as "mmmm"
Formula:
Sheet1...
B2, copied across and down:
=SUMPRODUCT(--(Sheet2!$A$1:$A$10-DAY(Sheet2!$A$1:$A$10)+1=B$1),--(Sheet2!
$E$1:$E$10=$A2))
Hope this helps!
In article ,
RUSH2CROCHET wrote:
Hello All:
Quick question on SumProduct...
Sheet 1 is a recap of processed returns for customers
A1=Sprint
A2=Verizon
Column B is January
Column C is February, and so on
Sheet 2 is a "tracking log" of returns
Column A contains the Date value, including month & year
A1 = January 13 - E1 contains "Sprint"
A2 = February 2 - E2 contains "Verizon"
A3 = March - E3 contains "Sprint"
I would like Sheet 1 to reflect the number of transactions within a specific
month per customer, that is to say....
Jan Feb Mar
Sprint 1 1
Verizon 1
All suggestions welcome!
Thanks!
Sandi
|