Thread: [Solved] How can I count per year and per week the total number of times a code occurs
View Single Post
 
Old 06-26-2020, 09:26 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
Its not a nice formula and the help columns are much better in this case, but i think the attach works

Code:
=COUNTIFS(DATA!$C:$C,'# Codes'!W$2,DATA!$B:$B,">="&DATE($AL$1,1,1-WEEKDAY(DATE($AL$1,1,1),2))+$V2*7,DATA!$B:$B,"<="&DATE($AL$1,1,1)-WEEKDAY(DATE($AL$1,1,1),2)+$V3*7-1)

Also i have unmerged AL1:AM1 - nothing good will ever come of merged cells and they should be avioded in my opinion
Reply With Quote