Results 1 to 9 of 9

Sum if multiple Criteria is true

Threaded View

  1. #1
    Forum Contributor 00Able's Avatar
    Join Date
    11-17-2010
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003, 2007, 2010
    Posts
    244

    Sum if multiple Criteria is true

    I want to get a sum of a group of cells if multiple criteria is true.

    Column A is the same "Date", and Column B is the same "Line", and column D is the same "Shift",

    So if each row has the same Date, Line, and Shift, I want the sum of column "E" for those respective rows to go in column F for those respective rows.

    Hope that makes sence, see attached for example, notice Shift changes...

    **EDITED
    Please note I need to do this in an Excel 2003 atmosphere.
    Last edited by 00Able; 02-19-2011 at 09:17 PM.
    Providing Problems for Your Solutions
    STARS are my Punching Bag, You will be rewarded.

    In the rare event that I may help you, feel free to make me see STARS

Thread Information

Users Browsing this Thread

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

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