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.