Counting cells that contain specific text within a date range

[walkdaplank24]

Need help counting cells that contain specific text within a date range. 11-30-2018 5-59-20 AM.jpg

For example. I would like to find out how many US5's (AB Column) there are between 12/1/2018 and 12/31/2018 within the N Column. The goal is to find out how many there are within each month to create a report. Thanks for any help!

[etaf]

you can use a COUNTIFS()

=COUNTIFS(N3:N18,">="&DATEVALUE("12/1/18"), N3:N18,"<="&DATEVALUE("12/31/18"), AB3:AB18,"US5")
OR
=COUNTIFS(N3:N18,">=12/1/18, N3:N18,"<=12/31/18", AB3:AB18,"US5")
should work the date out itsself

there are otherways to work out a month - if you wanted different months - you could have a cell with just 12/1/18 and use that to get a Months range
saves hardcoding the dates into a formula
however, i dont know how your layout is or if you only have 1 month in the spreadsheet anyway

[walkdaplank24]

Thanks! That worked perfectly!

Let me throw one more question into the mix. Column T represents the estimated hours per US5.. I'm trying to figure out a formula that finds all the US5's within the month and then add the estimated hours for each of the US5 within it. For example, there are 5 US5's within December, each have different hours per US5.. I want to find those and add the hours and output that in a cell.

Hopefully I'm making sense.

[etaf]

Sumifs()
=sumifs(t3:t18,n3:n18,">=1/1/18", n3:n18,"<=1/4/18", ab3:ab18,"us5")