Writing formula using COUNTIF

[Suz]

a have a row of answers giving a rating from 0-10. I need to count the
number of people who scored the question between 1-6.

 

[JBeaucaire]

Try something in this format:

=SUMPRODUCT(--(A1:A100<=6),--(A1:A100>=1))

 

[RaulDR]

a have a row of answers giving a rating from 0-10. I need to count the
number of people who scored the question between 1-6.

Hi Suz,

if you're using excel 2007 try this =COUNTIFS(A1:A8,">0",A1:A8,"<7")

for excel 2003 try this COUNTIF(A1:A8,"<7")-COUNTIF(A2:A9,"=0")

hope this helps.

 

[T. Valko]

Try this:

=COUNTIF(A1:J1,">=1")-COUNTIF(A1:J1,">6")

Another unusual way:

=INDEX(FREQUENCY(A1:J1,{0,6}),2)