Sum if ?? (Can't be hard) Month Function?

[gg]

I am trying to do Sum if with two criteria.
I have a table in Colmn A I have Names
(Several Hundred in succession)

Col A
TN
MI
KY
OH

Col. B
1/19/04
1/25/04
2/9/04
2/14/04
3/1/04
etc...

Col C
2
3
4
3
2
7
8

I want o sum up column C when My createria is met.
Example:
KY sum for the month of January.

Can I use the "Month" Funtion with Sum if?

 

[Aladin Akyurek]

Not with SumIf... Try instead:

=SUMPRODUCT(--($A$2:$A$400=E2),--(TEXT($B$2:$B$400,"m/yy")=TEXT(F2,"m/yy")),$C$2:$C$400)

where E2 houses a name condition like KY and F2 a month/year condition like 1/1/2004.

 

[phantom1975]

Is this what you need:

Book1
	A	B	C	D
1	TN	1/19/2004	2
2	MI	1/25/2004	3
3	KY	2/9/2004	4
4	OH	2/14/2004	3
5	TN	3/1/2004	2
6	MI	1/19/2004	7
7	KY	1/25/2004	8
8	OH	2/9/2004	2
9	TN	2/14/2004	3
10	MI	3/1/2004	4
11	KY	1/19/2004	3
12	OH	1/25/2004	2
13	TN	2/9/2004	7
14	MI	2/14/2004	8
15	KY	3/1/2004	7
16	OH	1/19/2004	8
17
18	TN	MI	KY	OH
19	2	10	11	10
Sheet1