Results 1 to 2 of 2

Summing items in multiple columns

Threaded View

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    U.S.
    MS-Off Ver
    2010
    Posts
    1

    Summing items in multiple columns

    Hi all,

    I am trying to make my own scheduling spreadsheet for a business that I manage and I want to make it easier on myself. Usually I would just calculate by hand how many hours I would give each employee, but I figure I can let Excel do that for me. I will attach a sample document of what I am trying to accomplish.

    I want the formula to find the specified employees name, see what shift they are working, and then sum up the corresponding hours associated to that shift. I figured out how to do this for one specific day, but I want it to sum up the employee's hours of the entire week. In my sample I am just working with two days, but I cant figure it out. I would prefer to not change the layout of the schedule either.

    Please help!

    Attachment 387990
    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. Summing multiple items based on a string in a cell
    By seanc72 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 01-27-2014, 05:14 AM
  2. [SOLVED] Summing multiple columns?
    By shiftyspina in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-18-2013, 10:04 AM
  3. Sumproduct with multiple critera, and summing multiple Columns
    By shanea.kr in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-09-2012, 03:12 PM
  4. Matching multiple columns, summing multiple results
    By DamienC in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-09-2008, 09:36 AM
  5. [SOLVED] Summing Columns-revolves around summing particular items
    By savv32 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-06-2005, 09:05 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