Formula Help

[Casey]

I am trying to do the following and can't figure out the formula.

I have cells across a column that have one of the following numbers:
0,1,2,3,4. I want to get the number of cells that have a 1 or a 2.

For example, lets say A3 is a 1, C3 is a 3, E3 is a 4 and G3 is 2. I want
the forumala to give me 2 (1 in A3 and 2 in G3).

I am sure it is fairly simple, but I can't figure it out.
Thanks

 

[Gary''s Student]

Try:

=COUNTIF(A3:Z3,1)+COUNTIF(A3:Z3,2)

 

[מיכ×ל (מיקי) ×בידן]

One way would be: =SUMPRODUCT((A3:G3<>0)*(A3:G3<=2))
Micky

 

[Casey]

Thanks for the suggestion. One of the problems is that I have content
between the cells. So between A3 and C3, there is a cell with a number that
I don't want as part of the final number. Is it possible to edit the formula
to just desired the columns?

 

[מיכ×ל (מיקי) ×בידן]

Well..., maybe:
=SUMPRODUCT((MOD(COLUMN(A3:G3),2))*(A3:G3<=2))
Micky