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:W29
> > )>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.
> >