Ok let's try this work around! ... Count if

[Ultimate Selector]

I want to count the cells that have either a number 1, 2 or 3 in it. how can I combine all three of these numbers into one statement (formula?)

I Don't want to Sum what numbers are in the cells...
I just want to count them.

It's conting my cells that have a zero in them as well. How do I omit counting the cells with Zero in the formula?

=COUNTIF(AC8:AU8,"=1") ... =COUNTIF(AC8:AU8,"=2") ... =COUNTIF(AC8:AU8,"=3")

I tried this but to no avail ... =COUNTIF(AC8:AU8,"<4")

Thanks in advance,
U S

 

[Saba Sabaratnam]

you can use the following formula to count them.

Enter the formula in C4

=SUM(COUNTIFS(A1:A17,C1:C3))

Kind regards

Saba

 

[jtakw]

Hi,

Pretty much the same, hard coded:

Book3.xlsx
	A	B	C
1	0		6
2	1
3	5
4	9
5	2
6	3
7	0
8	2
9	3
10	6
11	1
12	7
Sheet764

Cell Formulas
Range	Formula
C1	C1	=SUM(COUNTIF(A1:A20,{1,2,3}))

 

[Dave Patton]

=COUNTIFS(A1:A17,"<"&4) or =COUNTIFS(A1:A17,"<4")

 

[Ultimate Selector]

Thanks fellas that worked well for me! Much Appreciated for your input!

Have a Great Nite!

Regards,
US

 

[jtakw]

<4 would include 0 or variations thereof...

EDIT: You're welcome.