Counting weekly entries from a Created By field

crodts

I am looking to count all the entries from a Created By field in Sheet 1 and deposit that count into a Sheet 2 that contains rows for each week of the year 1-53. The intended use is to show week over week counts of inquiries. Will eventually want to specify the count per support type for each column on Sheet 2 (Sales, Training, etc), but will have to walk before we can run, so any help would be appreciated).

Sheet 1:

Sheet 2:

I have tried:

=COUNTIF(WEEKNUMBER({Created Date}), WEEKNUMBER([Week Number]@row))

and several variations with no success.

isa.ohara

I believe what needs to be done is to add a helper column to your sheet that stores the WeekNumber - it can't pull the WeekNumber from the Range - and then get rid of the "WEEKNUMBER" for the WeekNumber@row

So it would be: =COUNTIF({WeekNumberColumn}, @cell = [Week Number]@row)

I was trying it out and had the same problem

crodts

Is there a way to do this without adding a helper column to Sheet 1? The rows in this sheet copy to many more sheets and I would like to avoid having a Week Number column copied over to the other sheets each time.