Results 1 to 5 of 5

Analising scores per subjects

Threaded View

Arealmix Analising scores per subjects 05-02-2014, 10:07 AM
ben_hensel Re: Analising scores per... 05-02-2014, 10:29 AM
Arealmix Re: Analising scores per... 05-02-2014, 12:20 PM
Xx7 Re: Analising scores per... 05-02-2014, 12:54 PM
Arealmix Re: Analising scores per... 05-03-2014, 05:10 PM
  1. 05-02-2014, 10:07 AM #1
    Arealmix is offline
    Registered User
    Join Date
    04-25-2014
    Location
    Lagos, Nigeria
    MS-Off Ver
    Excel 2007, Excel 2010, Excel 2013
    Posts
    27

    Analising scores per subjects

    Hello good people!
    I need a formula to analyze the attached sheet.
    I need to know
    1-Number of students that passed with 70% and above in English, Maths and Biology
    2- Number of students that passed with 50%-69% and above in English, Maths and Biology
    3- Number of students that scored below 50% in English, Maths and Biology
    4-Number of student that where absent for each of the subjects (English, Maths, biology)
    Note: Total of all the columns per subject must be equal to the total number of students in the sheet
    Thanks
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How do I create team scores from data in a table of players scores.
    By fredqwerty in forum Excel General
    Replies: 1
    Last Post: 06-15-2013, 09:02 PM
  2. data analising and dash bord reporting
    By spl in forum Excel General
    Replies: 0
    Last Post: 02-20-2013, 07:10 AM
  3. [SOLVED] List the most recent five scores from among multiple scores
    By Winship in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-11-2012, 09:25 PM
  4. VB macro for sorting through scores and copying certain scores to new sheet
    By cowboy713 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-23-2010, 01:47 AM
  5. how to add weekly scores w/o showing current scores
    By breal33 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 12-02-2007, 11:56 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1