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)

"Jakobshavn Isbrae" wrote in
message ...
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.
--
jake