+ Reply to Thread
Results 1 to 8 of 8

I need analysis formula

  1. #1
    Registered User
    Join Date
    09-06-2013
    Location
    Dsm,Tanzania
    MS-Off Ver
    Excel 2007
    Posts
    53

    I need analysis formula

    Dear Experts,
    Am having a problem in analyising data as attached. The data i need to analyse are grades in column c ie A,B,C,D,and F.
    All i need is to know how many A,B,C etc the students have scored. I can only do this by treating each grade separately eg COUNTIF(C2:C20,"A") and i dont know any general formula to treat all grades at once.Please help me and i highly appreciate your response.
    Attached Files Attached Files

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: I need analysis formula

    In column E enter the grades A,B,C,D,F from E2:E6

    In F2 enter and copy down.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by newdoverman; 10-26-2013 at 04:09 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,983

    Re: I need analysis formula

    try a pivot table
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  4. #4
    Registered User
    Join Date
    09-06-2013
    Location
    Dsm,Tanzania
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: I need analysis formula

    Hi newdoverman,
    Thanks so much.Your formula is the one i wanted!
    Regards.

  5. #5
    Registered User
    Join Date
    09-06-2013
    Location
    Dsm,Tanzania
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: I need analysis formula

    Hi popipipo,
    Am also English non native speaker.However i dont see any errors you made.But i dont know what pivot table is.
    Regards

  6. #6
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    2,983

    Re: I need analysis formula

    Here a example of a pivot table
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,164

    Re: I need analysis formula

    Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

    Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

    (This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  8. #8
    Registered User
    Join Date
    09-06-2013
    Location
    Dsm,Tanzania
    MS-Off Ver
    Excel 2007
    Posts
    53

    Re: I need analysis formula

    Thanks so much P.
    Regards

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Data Analysis- advanced pivot functions for employee analysis
    By Dsankie in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-10-2013, 12:30 AM
  2. Formula to help with text analysis
    By Algonquin Dude in forum Excel General
    Replies: 3
    Last Post: 11-29-2011, 03:04 PM
  3. Sequence analysis formula
    By Swetha in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-21-2011, 03:20 PM
  4. Analysis Formula
    By gambit79 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-13-2008, 07:46 AM
  5. Analysis ToolPak installed but no Data Analysis option
    By Eric Stephens in forum Excel General
    Replies: 3
    Last Post: 02-02-2005, 06:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1