Counting question

Kind of long, but this will work:

=-SUM(-COUNT
(Q13:W13,Q17:W17,Q21:W21,Q25:V25,Q29:W29),COUNTIF(Q13:W13,
{"<=0",">=6"}),COUNTIF(Q17:W17,{"<=0",">=6"}),COUNTIF
(Q21:W21,{"<=0",">=6"}),COUNTIF(Q25:W25,
{"<=0",">=6"}),COUNTIF(Q29:W29,{"<=0",">=6"}))

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I have a range of cells that I want to 'count' if the
number is greater than
>0 but less than 6. The cell # is F33 where I want the
answer. The range is:
>Q13:W13; Q17:W17; Q21:W17; Q25:W25; & Q29:W29.
>
>What formula would I use? I've tried several but I keep
getting error
>answers.
>.
>

Careful. I have Q25:V25 in the 1st part of my formula
(?). Change that to:

Q25:W25

Jason

>-----Original Message-----
>Kind of long, but this will work:
>
>=-SUM(-COUNT
>(Q13:W13,Q17:W17,Q21:W21,Q25:V25,Q29:W29),COUNTIF
(Q13:W13,
>{"<=0",">=6"}),COUNTIF(Q17:W17,{"<=0",">=6"}),COUNTIF
>(Q21:W21,{"<=0",">=6"}),COUNTIF(Q25:W25,
>{"<=0",">=6"}),COUNTIF(Q29:W29,{"<=0",">=6"}))
>
>HTH
>Jason
>Atlanta, GA
>
>>-----Original Message-----
>>I have a range of cells that I want to 'count' if the
>number is greater than
>>0 but less than 6. The cell # is F33 where I want the
>answer. The range is:
>>Q13:W13; Q17:W17; Q21:W17; Q25:W25; & Q29:W29.
>>
>>What formula would I use? I've tried several but I
keep
>getting error
>>answers.
>>.
>>
>.
>