+ Reply to Thread
Results 1 to 1 of 1

Excel 2007 : Countifs to gather data from multiple sheets, based on multiple criteria

  1. #1
    Registered User
    Join Date
    07-20-2011
    Location
    Dubai, UAE
    MS-Off Ver
    Excel 2007
    Posts
    1

    Exclamation Countifs to gather data from multiple sheets, based on multiple criteria

    Hi all,

    Im currently working on sheet that compiles all the data input into several other sheets.So, essentially there are several sheets which are manually input by people, these are the individual survey results.
    On the "Analysis1/2" Sheet, I have put two drop down menus, one which selects the individual responsible for the survey and the other which names the survey whose results I want to display.
    So based on these two selections the data should autopopulate in the "Analysis1/2 sheet. Which in itself, has the 2 tables for two different sets of calculations.
    Also, I have either the option of putting a "date from" and date to" column, so depending on the dates entered into these cells, the data should be picked up from corresponding surveys. OR, I can just hardcode the dates into the formulas and seperate the results table as Quarter1/2/3/4. PLEASE HELP!!!!
    I hope this information is enough. Please do let me know for any clarifications. Attaching sheet for you'll.

    Thanks in advance.
    p.s. Im very very new to excel
    Attached Files Attached Files
    Last edited by SNRA; 07-27-2011 at 01:04 AM. Reason: Attaching excel sheet

+ 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