So define a named range with the formula:
=Sheet1!$F$4:INDEX(Sheet1!$F:$F,Sheet1!A$1,1)
and use this in your COUNTIF.=Sheet1!$F$4:INDEX(Sheet1!$F:$F,Sheet1!A$1,1)
and use this in your COUNTIF.='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.
Title | # Comments | Views | Activity |
---|---|---|---|
Excel - Scroll Speed | 3 | 26 | |
VBA to automatically save the workbook every 2 minutes | 3 | 29 | |
In Excel 2007, how should I change my formula so I don't get a #VALUE error? | 3 | 26 | |
Excel Array formula issues | 4 | 13 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!