description of countif criteria?

[Guest]

Does a description exist in a book or website of valid countif criteria?
For example - =COUNTIF(A$7:A$15,2) works

=COUNTIF(A$7:A$15,"=2") also works, but
=COUNTIF(A$7:A$15,"=1+1") does not work


I don't need an answer to a specific example, just a place to go and read on
my own.

Thanks in advance for any help received.

 

[Don Guillett]

Have you tried
=COUNTIF(A$7:A$15,1+1)

 

[Bob Phillips]

The second argument in COUNTIF is not a formula, but a criteria. So you can
build an expression like the one you gave

=COUNTIF(A$7:A$15,"="&1+1)

but you cannot pass it directly.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Don Guillett]

=COUNTIF(C,"a")

 

[Bob Phillips]

Not really, because not everybody knows, and we all know something
different.

Just watch this group, reading the posts and the responses, you will learn a
lot.

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Ragdyer]

I believe what you're looking for can be labeled "experience", for, as you
realize, there are just too many fuzzy questions to be answered in any one,
single place.

I've suggested this to others, and they've acknowledged that it was a "good"
start:

http://tinyurl.com/2bah9v

 

[Guest]

Thanks, I will take your advice and put frustration aside,

 

[Guest]

Thank you. You have pointed me to a near library of information.


I'll start reading.