SUM of Column for specific data in two columns

[mustanggt428]

I am trying to setup a table that sums the dollar amount for specific locations during a certain month. I am getting the #value when trying the following
=SUMIFS(F2:F100,C33:C51,">9/1/2017",C33:C51,"<9/30/2017") but I don't know how to add the location.
I want the sum of F2 when C2 is between 7/1 and 7/31 when J2 is Atlanta, GA


C2 F2 J2

7/1/2017 $100.00 Atlanta, GA
7/31/2017 $100.00 Atlanta, GA

Thanks for the help.

 

[Marcílio_Lobão]

mustanggt428, Good afternoon.

Try to use:

=SUMIFS(F2:F100, C2:C100,">=1/7/2017", C2:C100,"<=31/7/2017", J2:J100,"Atlanta, GA")

Plese tell us if it worked for you.

I hope it helps.

 

[mustanggt428]

It worked. I just had to switch the 1/7/2017 to 7/1/2017. thank you so much