Count of Title By Date Range

[Schnagglebeef]

Hello,

First time poster looking for assistance please

I need to make a simple dashboard page based on the data entered.

I'd like to be able count the Location / Client (Column B) by each month represented by a date range (Column C). This is a scheduling team - effectively when the team fill a shift they enter the location and date confirmed. The dashboard needs to be able to display the number of entries for each location for each location by month.

Example: Count of "Brownell House Shift" for May = ?

Many thanks!

Paul

 

[bebo021999]

Would suggest COUNTIFS or SUMPRODUCT
=COUNTIFS(B4:B10,"Brownell House Shift",C4:C10,">=" & DATE(2023,5,1),C4:C10,"<=" & DATE(2023,5,31))
or
=SUMPRODUCT((B4:B10="Brownell House Shift")*(TEXT(C4:C10,"mmm")="May")*(YEAR(C4:C10)=2023))
or
=SUMPRODUCT((B4:B10="Brownell House Shift")*(EOMONTH(C4:C10,0)=DATE(2023,5,31)))

 

[Schnagglebeef]

Would suggest COUNTIFS or SUMPRODUCT
=COUNTIFS(B4:B10,"Brownell House Shift",C4:C10,">=" & DATE(2023,5,1),C4:C10,"<=" & DATE(2023,5,31))
or
=SUMPRODUCT((B4:B10="Brownell House Shift")*(TEXT(C4:C10,"mmm")="May")*(YEAR(C4:C10)=2023))
or
=SUMPRODUCT((B4:B10="Brownell House Shift")*(EOMONTH(C4:C10,0)=DATE(2023,5,31)))

Thank you so much!

 

[Peter_SSs]

Welcome to the MrExcel board!

Assuming that all dates are in the current year, what about

=COUNT(FILTER(C4:C10,(B4:B10="Brownell House Shift")*(MONTH(C4:C10)=5),""))

 

[Peter_SSs]

Assuming that all dates are in the current year

if they may not be all in the same year and you want the May 2023 count then
=COUNT(FILTER(C4:C10,(B4:B10="Brownell House Shift")*(TEXT(C4:C10,"mmyy")="0523"),""))