Hello everyone
I have a data-set where the output is a Pivot-table.
What I need is a dynamic formula (probably Counta) that counts how many weeks have values in the specific project because i need o count the average amount of hours spend on the projects.
For instance for 'Project A' there are values in week 35 and 36 which equals 2. For 'Project B' there are values in week 27-35 which should equal 7.
It is important that the formula is dynamic since the Project-rows can be shifted.
Any suggestions?
I have a data-set where the output is a Pivot-table.
What I need is a dynamic formula (probably Counta) that counts how many weeks have values in the specific project because i need o count the average amount of hours spend on the projects.
For instance for 'Project A' there are values in week 35 and 36 which equals 2. For 'Project B' there are values in week 27-35 which should equal 7.
It is important that the formula is dynamic since the Project-rows can be shifted.
Any suggestions?