I forgot to include a Text Equivalent....D'oh....

=SUMPRODUCT(--($E$10:$J$10<""),--($N$10:$S$10))

Again, if all the cells meet the criteria it will count up to 6, conversely,
if any cells are blank within the range, the total will change to
reflect....

HTH
Mick.