+ Reply to Thread
Results 1 to 3 of 3

Counting the number of values in a list between two specified valu

  1. #1
    andyuae
    Guest

    Counting the number of values in a list between two specified valu

    I have 30 entries in a list which are the heights of students in my class in
    cm. I want to plot a bar chart of this data so the spreadsheet is arranged to
    show the data as numbers of students with heights between certain values eg 3
    students between 131 and 135 cm, 4 between 136 and 140 cm, 2 between 141 and
    145 cm etc. Which formula do I use to get excel to automatically calculate
    the numbers iof students between these values? I have tried combinations of
    SUM and IF to no avail. Can anyone help.
    Thanks.

  2. #2
    Bob Phillips
    Guest

    Re: Counting the number of values in a list between two specified valu

    =SUMPRODUCT(--(rng>=13),--(rng(<=135)

    etc.

    --

    HTH

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


    "andyuae" <[email protected]> wrote in message
    news:[email protected]...
    > I have 30 entries in a list which are the heights of students in my class

    in
    > cm. I want to plot a bar chart of this data so the spreadsheet is arranged

    to
    > show the data as numbers of students with heights between certain values

    eg 3
    > students between 131 and 135 cm, 4 between 136 and 140 cm, 2 between 141

    and
    > 145 cm etc. Which formula do I use to get excel to automatically

    calculate
    > the numbers iof students between these values? I have tried combinations

    of
    > SUM and IF to no avail. Can anyone help.
    > Thanks.




  3. #3
    Bernard Liengme
    Guest

    Re: Counting the number of values in a list between two specified valu

    Also, have at look at FREQUENCY in Help
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "andyuae" <[email protected]> wrote in message
    news:[email protected]...
    >I have 30 entries in a list which are the heights of students in my class
    >in
    > cm. I want to plot a bar chart of this data so the spreadsheet is arranged
    > to
    > show the data as numbers of students with heights between certain values
    > eg 3
    > students between 131 and 135 cm, 4 between 136 and 140 cm, 2 between 141
    > and
    > 145 cm etc. Which formula do I use to get excel to automatically
    > calculate
    > the numbers iof students between these values? I have tried combinations
    > of
    > SUM and IF to no avail. Can anyone help.
    > Thanks.




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1