Thread: Formula Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
casey casey is offline
external usenet poster
 
Posts: 80
Default Formula Help

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