Forum Discussion
Solved
Count the instances of a name based on the date, into a different sheet
Greetings. I am trying to set up a spreadsheet that tracks productivity for staff using Office 365. I am working with 2 spreadsheets in the workbook. The first sheet is named "FACILITY REQUESTS". ...
Hi TerriLP
If I didn't make mistake replicating your setup that should be:
in B2 then copy right & down (adjust $G$100 and $B$100 according to your actual ranges):
=COUNTIFS( 'FACILITY REQUESTS'!$G$1:$G$100, $A2, 'FACILITY REQUESTS'!$B$1:$B$100, ">=" & B$1, 'FACILITY REQUESTS'!$B$1:$B$100, "<=" & EOMONTH(B$1,0) )NB: Enter real dates (1/1/24, 1/2/24,....1/12/24) in B1:M1 then Custom Format cells to display Month names only
Hi TerriLP
If I didn't make mistake replicating your setup that should be:
in B2 then copy right & down (adjust $G$100 and $B$100 according to your actual ranges):
=COUNTIFS(
'FACILITY REQUESTS'!$G$1:$G$100, $A2,
'FACILITY REQUESTS'!$B$1:$B$100, ">=" & B$1,
'FACILITY REQUESTS'!$B$1:$B$100, "<=" & EOMONTH(B$1,0)
)
NB: Enter real dates (1/1/24, 1/2/24,....1/12/24) in B1:M1 then Custom Format cells to display Month names only