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?
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?