I want to return true if a range of cells (A2:K2) doesnt contain any blanks. So all the cells in the given range must contain something.
I can count the number of cells that contains something but im not sure what to do next?
=SUMPRODUCT((LEN(A2:K2)>0)*1)
Aucun commentaire:
Enregistrer un commentaire