count cells

[gonzer]

Hi all,

I have a problem and hope somebody can help me out.
I have a list with data. The list contains either 1 or 2 or 3 or something else or is blank.
I want to count all the cells with do not contain a 1 or 2 or 3.
In other words, I need the number of the empty cells plus the number of the cells with no 1 or 2 or 3.

Thx

[gijoe119]

Counts number of rows in the column minus the sum of rows with a 1 or 2 or 3. I assumed all yours 1,2, or 3s are in the same column. Just replace the cell references in this formula and your good.

=ROWS(A1:A12)-SUM(COUNTIF(A1:A12,1),COUNTIF(A1:A12,2),COUNTIF(A1:A12,3))

[Domenic]

Another way...

=SUMPRODUCT(--(1-ISNUMBER(MATCH(A1:A100,{1,2,3},0))))

Hope this helps!