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

gg

Well-known Member
Joined
Nov 18, 2003
Messages
560
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
Joined
Feb 14, 2002
Messages
85,210
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
Joined
Jun 3, 2002
Messages
3,962
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
 

Forum statistics

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

Which adblocker are you using?

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
Top