From: Hoops on
Sorry the current formula is =SUM(IF(ISTEXT(C6:K6),1,0))