Count cells with assigned value

**Greverod** · 09-09-2008, 11:48 AM

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?

**oldchippy** · 09-09-2008, 11:55 AM

Hi,

For your first question you could use something like this

=COUNTIF(A1:E1,">0")

You will need to explain the second question more clearly - I don't understand it so far sorry

**Greverod** · 09-09-2008, 01:04 PM

Great, that was very helpful and worked perfectly! Thank you

Sorry I confused you with the second one, I didn't even understand myself after I wrote it. I attached a file to see if it can make it more understandable...

**oldchippy** · 09-10-2008, 05:28 AM

Hi,

Are you saying that you want to count the blanks in the range Jan:Jun for each row, but only if there are numbers followed by blank cells. If there are numbers, blank cells, then numbers again then a zero is the score?