Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |