+ Reply to Thread
Results 1 to 6 of 6

Help: sum the cells based on their values under some classification

  1. 03-14-2013, 02:50 AM #1
    deepanc
    deepanc is offline
    Registered User
    Join Date
    01-18-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    89

    Help: sum the cells based on their values under some classification

    Hi... (Sorry, I can't explain in title)
    In here also... I have data in 3 sheets , then I want consolidate the total based on some classification .. (please download my attachment ) what are the formulas I need to use. pls. guide Me...
    [C.xlsNo. of students got A1,A2,A3... in suitable column]
    Reply With QuoteRegister To Reply
  2. 03-14-2013, 05:36 AM #2
    vinodhec
    vinodhec is offline
    Registered User
    Join Date
    04-06-2012
    Location
    Erode, India
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: Help: sum the cells based on their values under some classification

    Hi,
    Can you just solve one or two columns manually in the sample sheet.
    Reply With QuoteRegister To Reply
  3. 03-14-2013, 05:54 AM #3
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Help: sum the cells based on their values under some classification

    find the attached sheet
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 03-14-2013, 08:16 AM #4
    deepanc
    deepanc is offline
    Registered User
    Join Date
    01-18-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: Help: sum the cells based on their values under some classification

    Quote Originally Posted by vinodhec View Post
    Hi,
    Can you just solve one or two columns manually in the sample sheet.
    expected answers in red color
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 03-14-2013, 08:20 AM #5
    samba_ravi
    samba_ravi is offline
    Forum Guru samba_ravi's Avatar
    Join Date
    07-26-2011
    Location
    Hyderabad, India
    MS-Off Ver
    Excel 2021
    Posts
    8,914

    Re: Help: sum the cells based on their values under some classification

    see the attached "Sheet.xls"
    Reply With QuoteRegister To Reply
  6. 03-15-2013, 08:25 AM #6
    deepanc
    deepanc is offline
    Registered User
    Join Date
    01-18-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    89

    Re: Help: sum the cells based on their values under some classification

    oh. Thanks ya. And good one
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1