Ultimate Selector
Board Regular
- Joined
- Dec 15, 2013
- Messages
- 153
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
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
Last edited: