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

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209
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
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,159
Messages
5,768,520
Members
425,479
Latest member
Neerajcool

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