COUNTIF between range - 2 criteria

[ff_emt1]

This is probably easy but it has me stumped.

I have defect codes that are department specific, 1000, 1001, 1002, are Department A, 2000, 2001, 2002 are department B, etc.

WeekXXall is the tab name.

This formula works and gives me everything above 1000.
=COUNTIF('Week XXall'!CB2:CB8376,">=1000")

I have tried variations of the following and have had no luck.
=COUNTIF('Week XXall'!CB2:CB8376,">=1000&<=1999")

How do I count between a range?

Thanks in advance.

 

[Marcelo Branco]

Maybe

=SUMPRODUCT(--('Week XXall'!CB2:CB8376>=1000),--('Week XXall'!CB2:CB8376<2000))

M.

 

[ff_emt1]

Marcelo,

Works GREAT.

What does the "--" do?

Thanks

 

[Marcelo Branco]

Marcelo,

Works GREAT.

What does the "--" do?

Thanks

You are welcome.

-- coerces a logical value, True or False, to respectively 1 or 0 (zero)

Take a look at

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

M.

 

[ff_emt1]

Excellent reference. I will definitely spend some quality time with this information. About the time I think I know it all, I learn something new. That is why I like to members here, someone always willing to help you out.

Thanks!

Bob