In Excel (365 edition), I want to have a formula determine whether in a range of 5 cells, 3 of those cells are blank. If there are 3 cells, I want it to display
INELIGIBLE, if there are fewer than 3 blank cells, I want it to display
The values in the cells with data in them shall range from 1-6, so I'm not sure whether a
COUNT function is actually appropriate.
I tried using the
COUNT functions similar to another question on superuser, but it returns
#NAME? using the formula:
=IF(COUNT('GRADE 11 DATA'!C5,'GRADE 11 DATA'!F5,'GRADE 11 DATA'!I5,'GRADE 11 DATA'!L5,'GRADE 11 DATA'!O5)>2,ELIGIBLE,INELIGIBLE).