Countif function
 

Dear Sir,

I like to count a range of column, but I get only field
that <3 and 7. What is wrong in my formular?

Example:
Countif(D2:d450,"<3 and 9")????

Thanks,
Malyka

Hi!

Try one of these:

=COUNTIF(D2:D450,"<3")+COUNTIF(D2:D450,"9")

=SUMPRODUCT(--(D2:D450<3)+(D2:D4509))

Are you sure you have the criteria correct?

<3 = less than 3
9 = greater than 9

Biff

-----Original Message-----
Dear Sir,

I like to count a range of column, but I get only field
that <3 and 7. What is wrong in my formular?

Example:
Countif(D2:d450,"<3 and 9")????

Thanks,
Malyka
.

note: there's no need to use the double unary minus if you're going to
use the + operator.

In article ,
"Biff" wrote:

=SUMPRODUCT(--(D2:D450<3)+(D2:D4509))

Noted!

Biff

-----Original Message-----
note: there's no need to use the double unary minus if
you're going to
use the + operator.

In article ,
"Biff" wrote:

=SUMPRODUCT(--(D2:D450<3)+(D2:D4509))
.

Not being very good with formulas, what's the point of the -- in the formaula
mentioned??

"JE McGimpsey" wrote:

note: there's no need to use the double unary minus if you're going to
use the + operator.

In article ,
"Biff" wrote:

=SUMPRODUCT(--(D2:D450<3)+(D2:D4509))

See

http://www.mcgimpsey.com/excel/doubleneg.html

In article ,
cdb wrote:

Not being very good with formulas, what's the point of the -- in the formaula
mentioned??