description of countif criteria?

J

Jakobshavn Isbrae

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.
 
B

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)
 
B

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)
 
R

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
 
J

Jakobshavn Isbrae

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


I'll start reading.
 
Top