Countif question
 

I am trying to get a "Countif" function to count within a certain
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.

I understand that you can put

=countif(A31:A42, 32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"

but how do I do the 5 through 10?

I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK

I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile: http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069

Countif question
 

mtaystl11

Try this and let me know if it works for you. It must be entered with
ctrl+shift+enter

=SUMPRODUCT(--(A1:A75),--(A1:A7<10))

Dave

"mtaystl11" wrote
in message ...

I am trying to get a "Countif" function to count within a certain
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.

I understand that you can put

=countif(A31:A42, 32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"

but how do I do the 5 through 10?

I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK

I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile:
http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069

Countif question
 

Try
=COUNT(IF(A$31:A$42=5,IF(A$31:A$42<=10,A$31:A$42) ))

Commit with CTRL SHIFT ENTER. You should see {} around the entire formula
when complete.

"mtaystl11" wrote:


I am trying to get a "Countif" function to count within a certain
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.

I understand that you can put

=countif(A31:A42, 32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"

but how do I do the 5 through 10?

I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK

I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile: http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069

Countif question
 

Alternately you could use

=SUMPRODUCT(--(A$31:A$42=5),--(A$31:A$42<=10))

"mtaystl11" wrote:


I am trying to get a "Countif" function to count within a certain
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.

I understand that you can put

=countif(A31:A42, 32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"

but how do I do the 5 through 10?

I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK

I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile: http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069

Countif question
 

Hi,

try =sumproduct(--(a1:a5=5),--(a1:a5<=10))

adjust the range as you need

HTH
Regards from Brazil
Marcelo

"mtaystl11" escreveu:


I am trying to get a "Countif" function to count within a certain
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.

I understand that you can put

=countif(A31:A42, 32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"

but how do I do the 5 through 10?

I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK

I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile: http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069

Countif question
 

Try:

=COUNTIF(A1:A10,"<=10")-COUNTIF(A1:A10,"<5")

"mtaystl11" wrote:


I am trying to get a "Countif" function to count within a certain
number. Meaning, I need to get it to count how many cells are between
the number 5 and 10.

I understand that you can put

=countif(A31:A42, 32) or
=countif(A31:A42, <32) or
=countif(A31:A42, "32"

but how do I do the 5 through 10?

I have tried
=countif(A31:A42, 5-10) DIDNT WORK
=countif(A31:A42, "5-10") DIDNT WORK
=countif(A31:A42, 5;6;7;8;9;10) DIDNT WORK

I would really appreciate some help here. I'm sure it is a simple fix
but I just can't figure it out! THANKS!


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile: http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069

Countif question
 

Yeah, that did the trick! Thank you so much. :)


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile: http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069

Countif question
 

mtaystl11

note that if you want to include values that equal 10 or 5 you need to
modify the formula with a couple of "=" signs to make it work.

Dave

"mtaystl11" wrote
in message ...

Yeah, that did the trick! Thank you so much. :)


--
mtaystl11
------------------------------------------------------------------------
mtaystl11's Profile:
http://www.excelforum.com/member.php...o&userid=35725
View this thread: http://www.excelforum.com/showthread...hreadid=555069