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

#### gg

##### Well-known Member
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?

### Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

#### Aladin Akyurek

##### MrExcel MVP
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

##### MrExcel MVP
Is this what you need:
Book1
ABCD
1TN1/19/20042
2MI1/25/20043
3KY2/9/20044
4OH2/14/20043
5TN3/1/20042
6MI1/19/20047
7KY1/25/20048
8OH2/9/20042
9TN2/14/20043
10MI3/1/20044
11KY1/19/20043
12OH1/25/20042
13TN2/9/20047
14MI2/14/20048
15KY3/1/20047
16OH1/19/20048
17
18TNMIKYOH
192101110
Sheet1

Replies
6
Views
152
Replies
0
Views
171
Replies
15
Views
261
Replies
5
Views
202
Replies
2
Views
94

Threads
1,186,156
Messages
5,956,254
Members
438,243
Latest member
FXA

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back