I used George's formulas and mine, both gave a result of 4. His in O41,
mine in P10.
George's:
O10 =IF(SUM(J10:N10)>0,1,0) filled down to O40
O41 =SUM(Q10:Q40)
Mine:
O10 =COUNTA(J10:N10) filled down to O40
P10 =COUNTIF(O10:O40,">0")
Wayne wrote: Perhaps this is a better way to explain... one week
J10:N10 blank
J11 blank
K11 1.4 (hrs)
L11:N11 blank
J12 blank
K12 (1.3) hrs
L12 blank
M12:N12 (1.3 & 1.5) hrs respt
J13 (1.3) hrs
K13:N13 blank
J14:K14 (1.3 & 1.3) hrs respt
L14:N14 blank
J15:N15 blank
J16:N16 blank
The above should show 4 days worked! How do I do this? All of the input
up
to now has given me a total cell count, when that is not what I
require. I
need a Row (Non blank) count, showing in this case 4 days worked. Tks