I'm trying to figure out how to make my excel sheet work smoother while calculating the rating between my friends in poker.

First, I would like to know if there is a way to calculate which cells have numerical values assigned to them.

For example, if A1=53, B1=26 and E1=88 while C1 and D1 has not assigned value, I'd like F1=3 because of A1, B1 and E1 has numerical values. If it's possible, F1=3 even if C1 or/and D1 has a non numerical value like "new" or "[-]".

---

Second, I'm looking for something that does sort of the opposite. There is a punishment for not taking part in the latest pokertournaments so if the latest competition is represented by column "S". For example, I want X1=2 if the latest column in row 1 to be assigned a value is column Q (as the only non-assigned cells until column S is R1 and S1). If the last assigned value instead is in M1 then X1=6. I know this must sound weird, but is there way to do such a thing?