I get an excel error with the following formula:
+COUNTIF(MID(P21,1,2),">0")

Lets say cell P21 has the following inside the cell:
31-V32

When I look at the results in the formula editor, I see 31 and ">0" in the appropriate rows.
The formuila should return a value of 1.


I want the formula to eventually be used for a range of cells.
Lets say the listed cells have the following values:
P21=31-V32, Q21=03-X55, R21=31-A01

Thought the derivitive formula would be something like:
+COUNTIF(MID(P21:R21,1,2),">0")

Thanks in advance.

John