Forum Discussion
Solved
Need to use COUNTIFS with OFFSET and COUNTA to create a dynamic range within COUNTIFS
I am using the following formula, =COUNTIFS($D$7:$D$68,L9, $F$7:$F$68,">0") within the attached sheet. The two ranges need to be dynamic as thousands of rows will be added in time as my data grows. I...
It should work. See the attached, slightly modified version.
Could you make a copy of the workbook available again?
No problem. I will save a more recent copy and send the link as before.