count tasks per week number

Assaf Elad

Hi community,

I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year.

Here is my formula that calculate 0 every time (at least not an error) :

=COUNTIF({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER({6530 - Sulfuric project Schedule Range 5}) = [Primary Column]29)

the range is the start column date of the task on my gannt chart

the primary column on local grid contains numbers of the weeks in the year (1-53)

screenshot attached.

thnks

Paul Newcome

Just a minor adjustment. Since you want to count each cell within the range individually, you want to use an @cell reference in your WEEKNUMBER function.

=COUNTIFS({6530 - Sulfuric project Schedule Range 5}, WEEKNUMBER(@cell) = [Primary Column]29)