Hi there,
I have a planning file with week numbers in row 1, dates in row 2 and target values in column B (similar to the attached picture).
In a seperate sheet I'm trying to build a KPI that is: the percentage of planned amounts that are >= target amounts, per _week_, ignoring blanks.
Output should be something like:
Week 24: 57%
Week 25: 77%
I've been struggling to specify a dynamic range of 5 colums (all week 24, for example) and then do the countif or sumproduct.
Hope someone understands and can help.
I have a planning file with week numbers in row 1, dates in row 2 and target values in column B (similar to the attached picture).
In a seperate sheet I'm trying to build a KPI that is: the percentage of planned amounts that are >= target amounts, per _week_, ignoring blanks.
Output should be something like:
Week 24: 57%
Week 25: 77%
I've been struggling to specify a dynamic range of 5 colums (all week 24, for example) and then do the countif or sumproduct.
Hope someone understands and can help.