Count If's: Determining criteria

[montanaaggie]

I am trying to look at in column B that is 1000 rows long

In row 1001, I have the following equation =countif(B1:B1000, 1). Therefore it brings me back any entry that's value is 1.

I am now trying to create a formula that will do the same thing but instead of 1, I want to count if the value is between 5 and 10. =COUNTIF($B$1:$B$1000, 5=>x<=10). I know my criteria is wrong, but I can't figure it out. Any help is appreciated

 

[VoG]

Try

=COUNTIF(B1:B1000,">=5")-COUNTIF(B1:B1000,">10")

 

[Jonmo1]

A couple ways...

1. Use 2 countifs...
=COUNTIF(B1:B1000,">=5")-COUNTIF(B1:B1000,">10")

2. Sumproduct
=SUMPRODUCT(--(B1:B1000>=5),--(B1:B1000<=10))


Hope that Helps.

 

[jasonb75]

Another option (only with integers)

=SUMPRODUCT(COUNTIF(B1:B1000,ROW(5:10)))

or for excel 2007 or 2010

=COUNTIFS(B1:B1000,">=5",B1:B1000,"<=10")