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.

Try something in this format:

=SUMPRODUCT(--(A1:A100<=6),--(A1:A100=1))
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"Suz" wrote:

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.

"Suz" wrote:

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.

Try this:

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

Another unusual way:

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

--
Biff
Microsoft Excel MVP


"Suz" wrote in message
...
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.