+ Reply to Thread
Results 1 to 3 of 3

Need Help to summary all statement from 4 worksheets and to summary all totall ICC

  1. 12-23-2013, 07:40 AM #1
    adrianalvarez
    adrianalvarez is offline
    Registered User
    Join Date
    12-23-2013
    Location
    KSA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Post Need Help to summary all statement from 4 worksheets and to summary all totall ICC

    To all Excel forum members and excel lover..This is to introduce myself and im the new member.Im excel lover and interested to learn more secrets in excel 2010.
    I have one attached file and need your help to solve my problem.
    This workbook has 4 worksheet(Process Engineer,OSBL,OSA,Lab Operator)
    I want to know what is the best excel formula/function to summary this 4 worksheet.

    Example:I want a formula/function to summary all the statement from 4 worksheets and total number of answer "1" per statement from 4 worksheet.

    Sample Statement below

    "Demonstrate Interpersonal (People-to-People-) Skills"
    Question:What is the formula if above statement contains this statement in 4 worksheet?As i checked the total is 4 then What is the formula to get all total answered ICC on this statement from
    4 worksheet?

    Hoping to solve my problem..Regards
    Attached Files Attached Files
    Last edited by adrianalvarez; 12-23-2013 at 07:44 AM.
    Reply With QuoteRegister To Reply
  2. 12-24-2013, 02:04 AM #2
    RobertMika
    RobertMika is offline
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: Need Help to summary all statement from 4 worksheets and to summary all totall ICC

    Copy of Summary.xlsx
    Please see attached
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk
    Reply With QuoteRegister To Reply
  3. 12-25-2013, 05:02 AM #3
    adrianalvarez
    adrianalvarez is offline
    Registered User
    Join Date
    12-23-2013
    Location
    KSA
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Need Help to summary all statement from 4 worksheets and to summary all totall ICC

    Thank you Mr.Robertmika, I was resolved also using Pivot Table..Thanks
    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)

Similar Threads

  1. Need to pull data from a spec worksheet into a summary and run formulae from the summary
    By ryanwaters in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-21-2013, 07:23 AM
  2. Consolidate many worksheets into one summary sheet - Info from various area of worksheets
    By marsham in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-19-2013, 07:12 PM
  3. Create a summary from multiple sheets on a master/summary sheet
    By detribus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-07-2012, 08:04 PM
  4. count summary in Summary Sheet
    By joeBite in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-04-2007, 03:55 PM
  5. [SOLVED] multi group with summary above with 1 overall summary line below
    By Freddy in forum Excel General
    Replies: 2
    Last Post: 11-07-2005, 11:35 AM

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