I have a requirement to count if a cell's value in C8:C23 on the third through last sheet in workbook is "vacant". I never know how many sheets there will be.
Currently the formula below works, where SheetList is a named range containing the names of the worksheets. SheetList is somewhat...