Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.
='Mutually exclusive fields'!$F$4:$I$4:INDEX('Mutually exclusive fields'!$I$4:$I$10000,'Mutually exclusive fields'!$A$1)
, would be to make the INDEX use entire columns - this means that the range will extend to row 30 exactly:='Mutually exclusive fields'!$F$4:$I$4:INDEX('Mutually exclusive fields'!$I:$I,'Mutually exclusive fields'!$A$1,1)
The difference is because the first formula starts the INDEX range in row 4 it will count on 30 rows from there - the second one counts from row 1. You can choose which one is more suitable.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
So define a named range with the formula:
Open in new window
and use this in your COUNTIF.