If you copied and pasted the formula from the newsgroup and into your
spreadsheet, extra spaces and hard returns may have been added/included
in the formula. If so, this would give you your error message. In this
case, correct the formula accordingly.

Does this help?

In article ,
"Carl" wrote:

I tried both formulas that Jason gave me and the one you gave me.

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


"Domenic" wrote:

Can you post the exact formula you're using?

In article ,
"Carl" wrote:

I tried this and got an error message.

"Domenic" wrote:

Another way...

=SUMPRODUCT(--(CHOOSE({1;2;3;4;5},Q13:W13,Q17:W17,Q21:W21,Q25:W2 5,Q29:W2
9
)0),--(CHOOSE({1;2;3;4;5},Q13:W13,Q17:W17,Q21:W21,Q25:W2 5,Q29:W29)<6))

Hope this helps!

In article ,
"Carl" wrote:

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.