J

#### jamalhakem

Any help?

I want to count cells that contain numbers with criteria, I used these

functions, but it returns false, the range can contain data or are

blank, I want to count the nonblank only that meet the criteria <50 or

<60. What I wanted is to count if the cells contain numbers, and not

count the blank cells, and if all cells are empty, return blank””.

30 50 60 50 70 80 60 20 50 60 60 80 90

IF(ISNUMBER(D11:F11);COUNTIF(D11:F11;"<50")

+IF(ISNUMBER(G11:J12);COUNTIF(G11:J11;"<60")

+IF(ISNUMBER(K11:L11);COUNTIF(K11:L11;"<50")

+IF(ISNUMBER(M1111);COUNTIF(M1111;"<60")

+IF(ISNUMBER(Q11:S11);COUNTIF(Q11:S11;"<50")

+IF(ISNUMBER(T11:W11);COUNTIF(T11:W11;"<60")

+IF(ISNUMBER(X11:Y11);COUNTIF(X11:Y11;"<50");"")))))))

Thanks in advance

Jam