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

Try:

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

--
Gary''s Student - gsnu200909


"Casey" wrote:

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

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


"Casey" wrote:

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

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?

"מיכ�ל (מיקי) �בידן" wrote:

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


"Casey" wrote:

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

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


"Casey" wrote:

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?

"מיכ�ל (מיקי) �בידן" wrote:

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


"Casey" wrote:

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