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 <72176F9E-CA7C-4870-BBBC-F43928105AFD@microsoft.com>,
"Carl" <Carl@discussions.microsoft.com> 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"}),COUNTIF
> (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 <7AC8E373-FC1B-427A-898A-903E7290A78A@microsoft.com>,
> > "Carl" <Carl@discussions.microsoft.com> 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:W25,Q29:W2
> > > > 9
> > > > )>0),--(CHOOSE({1;2;3;4;5},Q13:W13,Q17:W17,Q21:W21,Q25:W25,Q29:W29)<6))
> > > >
> > > > Hope this helps!
> > > >
> > > > In article <4409F2B3-2D4A-439F-8B73-6EC223728B83@microsoft.com>,
> > > > "Carl" <Carl@discussions.microsoft.com> 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.
> > > >
> >