How do I sum this??

[soccerdude44]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]8/2/17[/TD]
[TD]8/25/17[/TD]
[TD]9/14/17[/TD]
[TD]9/25/17
[/TD]
[TD]10/1/17
[/TD]
[TD]10/29/17
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Total Amount
[/TD]
[TD]500,000
[/TD]
[TD]250,000
[/TD]
[TD]150,000
[/TD]
[TD]1,000,000
[/TD]
[TD]750,000
[/TD]
[TD]250,000
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]By Location
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]IN
[/TD]
[TD]300,000
[/TD]
[TD]125,000
[/TD]
[TD]0
[/TD]
[TD]500,000
[/TD]
[TD]250,000
[/TD]
[TD]100,000
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]KY
[/TD]
[TD]100,000
[/TD]
[TD]125,000
[/TD]
[TD]150,000
[/TD]
[TD]250,000
[/TD]
[TD]250,000
[/TD]
[TD]0
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]OH
[/TD]
[TD]100,000
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]250,000
[/TD]
[TD]250,000
[/TD]
[TD]150,000
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

How would I create a sum function that would allow me to sum total amount by location, by month. For example Indiana has 425,000 in August, 500,000 in September, and 350,000 in October. I would need the formula to be able to sum the totals like that for each location.

Thanks for your help!

 

[soccerdude44]

Perfect! Thank you both Aladin and Scott these both worked!! I greatly appreciate your assistance in this!

Once additional question though if you spread across more then 12 months and have lets say both October 2017 and October 2018 is there an easy way to include the year in the formula so it doesn't sum by just the month??

 

[Aladin Akyurek]

Perfect! Thank you both Aladin and Scott these both worked!! I greatly appreciate your assistance in this!

Once additional question though if you spread across more then 12 months and have lets say both October 2017 and October 2018 is there an easy way to include the year in the formula so it doesn't sum by just the month??

SUMIFS formula I posted won't counfound the years. It's also faster.

 

[soccerdude44]

Awesome! Thanks again!!

 

[Aladin Akyurek]

Awesome! Thanks again!!

You are welcome.