View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default description of countif criteria?

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

--
Don Guillett
SalesAid Software

"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