Need to Count number of occurrences and get percentage of total

=COUNTIF(B7:B222,">10")

and

=COUNTIF(B7:B222,"<10")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JennLee" <[email protected]> wrote in message
news:[email protected]...
> HELP !!
> I have a list from which I need to count the number of occurrences of a
cell
> value greater than 10 and the number of occurrences of a cell value less
than
> 10 then return a percentage of the total count of rows.
> I have a formula =COUNTA(A7:A222) that returns to me the number of
> patients, but I need to get the above info of the therapy visits based on
> greater than 10 and less than 10. Clear as mud?!!
>
> Ex: As below, it would be 4 patients with less than 10 therapy visits and
3
> patients with greater than 10 therapy visits -
>
> Jennifer 8
> Tommy 9
> Sally 15
> John 8
> Nick 12
> Jessy 12
> Alex 7
>
> Any help will be greatly appreciated!!

Thanks - that's perfect! But I also need to include the ones with the VALUE
of 10 in the >10 count! In other words I need "10 AND Greater than 10" Is
it possible?
Thanks again in advance.
--
Jennifer Lee
IS Coordinator/App Support


"Bob Phillips" wrote:

> =COUNTIF(B7:B222,">10")
>
> and
>
> =COUNTIF(B7:B222,"<10")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "JennLee" <[email protected]> wrote in message
> news:[email protected]...
> > HELP !!
> > I have a list from which I need to count the number of occurrences of a
> cell
> > value greater than 10 and the number of occurrences of a cell value less
> than
> > 10 then return a percentage of the total count of rows.
> > I have a formula =COUNTA(A7:A222) that returns to me the number of
> > patients, but I need to get the above info of the therapy visits based on
> > greater than 10 and less than 10. Clear as mud?!!
> >
> > Ex: As below, it would be 4 patients with less than 10 therapy visits and
> 3
> > patients with greater than 10 therapy visits -
> >
> > Jennifer 8
> > Tommy 9
> > Sally 15
> > John 8
> > Nick 12
> > Jessy 12
> > Alex 7
> >
> > Any help will be greatly appreciated!!
>
>
>

Sorry, should have realised that

=COUNTIF(B7:B222,">=10")

Bob

BTW - how can it be perfect if it doesn't do part of it? <bg>


"JennLee" <[email protected]> wrote in message
news:[email protected]...
> Thanks - that's perfect! But I also need to include the ones with the
VALUE
> of 10 in the >10 count! In other words I need "10 AND Greater than 10"
Is
> it possible?
> Thanks again in advance.
> --
> Jennifer Lee
> IS Coordinator/App Support
>
>
> "Bob Phillips" wrote:
>
> > =COUNTIF(B7:B222,">10")
> >
> > and
> >
> > =COUNTIF(B7:B222,"<10")
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "JennLee" <[email protected]> wrote in message
> > news:[email protected]...
> > > HELP !!
> > > I have a list from which I need to count the number of occurrences of
a
> > cell
> > > value greater than 10 and the number of occurrences of a cell value
less
> > than
> > > 10 then return a percentage of the total count of rows.
> > > I have a formula =COUNTA(A7:A222) that returns to me the number of
> > > patients, but I need to get the above info of the therapy visits based
on
> > > greater than 10 and less than 10. Clear as mud?!!
> > >
> > > Ex: As below, it would be 4 patients with less than 10 therapy visits
and
> > 3
> > > patients with greater than 10 therapy visits -
> > >
> > > Jennifer 8
> > > Tommy 9
> > > Sally 15
> > > John 8
> > > Nick 12
> > > Jessy 12
> > > Alex 7
> > >
> > > Any help will be greatly appreciated!!
> >
> >
> >

HELP !!
I have a list from which I need to count the number of occurrences of a cell
value greater than 10 and the number of occurrences of a cell value less than
10 then return a percentage of the total count of rows.
I have a formula =COUNTA(A7:A222) that returns to me the number of
patients, but I need to get the above info of the therapy visits based on
greater than 10 and less than 10. Clear as mud?!!

Ex: As below, it would be 4 patients with less than 10 therapy visits and 3
patients with greater than 10 therapy visits -

Jennifer 8
Tommy 9
Sally 15
John 8
Nick 12
Jessy 12
Alex 7

Any help will be greatly appreciated!!

=COUNTIF(B7:B222,">10")

and

=COUNTIF(B7:B222,"<10")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JennLee" <[email protected]> wrote in message
news:[email protected]...
> HELP !!
> I have a list from which I need to count the number of occurrences of a
cell
> value greater than 10 and the number of occurrences of a cell value less
than
> 10 then return a percentage of the total count of rows.
> I have a formula =COUNTA(A7:A222) that returns to me the number of
> patients, but I need to get the above info of the therapy visits based on
> greater than 10 and less than 10. Clear as mud?!!
>
> Ex: As below, it would be 4 patients with less than 10 therapy visits and
3
> patients with greater than 10 therapy visits -
>
> Jennifer 8
> Tommy 9
> Sally 15
> John 8
> Nick 12
> Jessy 12
> Alex 7
>
> Any help will be greatly appreciated!!

Thanks - that's perfect! But I also need to include the ones with the VALUE
of 10 in the >10 count! In other words I need "10 AND Greater than 10" Is
it possible?
Thanks again in advance.
--
Jennifer Lee
IS Coordinator/App Support


"Bob Phillips" wrote:

> =COUNTIF(B7:B222,">10")
>
> and
>
> =COUNTIF(B7:B222,"<10")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "JennLee" <[email protected]> wrote in message
> news:[email protected]...
> > HELP !!
> > I have a list from which I need to count the number of occurrences of a
> cell
> > value greater than 10 and the number of occurrences of a cell value less
> than
> > 10 then return a percentage of the total count of rows.
> > I have a formula =COUNTA(A7:A222) that returns to me the number of
> > patients, but I need to get the above info of the therapy visits based on
> > greater than 10 and less than 10. Clear as mud?!!
> >
> > Ex: As below, it would be 4 patients with less than 10 therapy visits and
> 3
> > patients with greater than 10 therapy visits -
> >
> > Jennifer 8
> > Tommy 9
> > Sally 15
> > John 8
> > Nick 12
> > Jessy 12
> > Alex 7
> >
> > Any help will be greatly appreciated!!
>
>
>

Sorry, should have realised that

=COUNTIF(B7:B222,">=10")

Bob

BTW - how can it be perfect if it doesn't do part of it? <bg>


"JennLee" <[email protected]> wrote in message
news:[email protected]...
> Thanks - that's perfect! But I also need to include the ones with the
VALUE
> of 10 in the >10 count! In other words I need "10 AND Greater than 10"
Is
> it possible?
> Thanks again in advance.
> --
> Jennifer Lee
> IS Coordinator/App Support
>
>
> "Bob Phillips" wrote:
>
> > =COUNTIF(B7:B222,">10")
> >
> > and
> >
> > =COUNTIF(B7:B222,"<10")
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "JennLee" <[email protected]> wrote in message
> > news:[email protected]...
> > > HELP !!
> > > I have a list from which I need to count the number of occurrences of
a
> > cell
> > > value greater than 10 and the number of occurrences of a cell value
less
> > than
> > > 10 then return a percentage of the total count of rows.
> > > I have a formula =COUNTA(A7:A222) that returns to me the number of
> > > patients, but I need to get the above info of the therapy visits based
on
> > > greater than 10 and less than 10. Clear as mud?!!
> > >
> > > Ex: As below, it would be 4 patients with less than 10 therapy visits
and
> > 3
> > > patients with greater than 10 therapy visits -
> > >
> > > Jennifer 8
> > > Tommy 9
> > > Sally 15
> > > John 8
> > > Nick 12
> > > Jessy 12
> > > Alex 7
> > >
> > > Any help will be greatly appreciated!!
> >
> >
> >