Using Multiple Criteria With Countif or Countifs Formula

[kozakb]

Good day,

I've never used Countif or Countifs in formulas before. I have a spreadsheet with a date column (m/d/yyyy) and another column with a city name.

I want to count the number of times a location occurs between a range of two dates like 5/1/2015 and 4/30/2016.

I figured out how to count the number of cells within that date range: =COUNTIFS(G2:G249, ">=5/1/2015",G2:G249, "<=4/30/2016"). However, I'm not sure how to put the two together. Maybe it should be a different formula all together.

Any help would be appreciated.
Thanks.

[jeffreybrown]

No, this looks right, but if you need to also count the city name.

=COUNTIFS(G2:G249,">=5/1/2015",G2:G249,"<=4/30/2016",F2:F249,"Dallas")

Not sure what column you are using for the city name, so in this example it's F

[kozakb]

Hi Jeff,

Thanks that worked great.

[jeffreybrown]

You are very welcome and thanks for the feedback!