Results 1 to 11 of 11

Summarize and total data from another sheet

Threaded View

  1. #1
    Registered User
    Join Date
    04-19-2022
    Location
    Chicago, IL
    MS-Off Ver
    365
    Posts
    11

    Summarize and total data from another sheet

    Please see attached to demonstrate what I am working with.

    Using the Project Estimate sheet, I am trying to create a summary sheet.

    In column A of my sheet named "Summary", I need to search the set of data from the sheet named Project Estimate that lists position titles, and input 1 of each unique value. This will be a different set of data/role every time, so the Summary sheet can not be pre-populated with roles. It needs to read everything on the Project Estimate sheet, identify all of the unique roles, and then put 1 of each in a cell on the Summary sheet. The important thing to note is that it must only list the roles that start with " - ". So for example in column A, it needs to exclude Video Phase, Copy Editing, Creative Design, Design Development, Artwork and Project Management, and only will from the other cells that start with " - ". These will be in different rows every time as you can see from the other columns, so it needs to be based on the text/value, not the cell name/range.

    Then in column B of my sheet named "Summary, I need to total the numbers in Column B of the "Project Estimate" sheet next to each role.
    So in my sheet named "Summary", I have included 1 example. I would want this formula to be able to identify that Project Manager Senior has 30 hours across all the data in Project Estimate

    What would I need to input in my Summary sheet to get this to work?

    Thanks so much
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula to summarize sheet data
    By rizmomin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2017, 11:20 PM
  2. [SOLVED] How to get summarize data from Various Sheets in a single sheet
    By purav82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-28-2017, 09:08 AM
  3. Want to summarize by extracting data from a daily sheet
    By Captainmarkie in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-27-2015, 05:35 PM
  4. How to summarize monthly in a data sheet?
    By Annatw in forum Excel General
    Replies: 2
    Last Post: 12-17-2013, 11:55 AM
  5. Summarize data from different sheets in the last sheet
    By maxfesca in forum Excel General
    Replies: 1
    Last Post: 03-25-2008, 01:08 PM
  6. summarize data sheet
    By GateKeeper in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-02-2005, 09:05 AM

Tags for this Thread

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