+ Reply to Thread
Results 1 to 3 of 3

Conditionally summing values by single days and various conditions

  1. #1
    Registered User
    Join Date
    01-20-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    18

    Conditionally summing values by single days and various conditions

    I am trying to sum up the daily total of LineDown time for work, based on what line it is. I have data that lists the day, the line, the cause, and the duration. I am trying to conditionally sum values saying if it is 9/15/14, or any other day, I want all the duration of all the Machine Cause of "LineDown" for Line "L05 Cracks"

    =IF(INT(Data!H$2:$H$4500)=Sheet1!$B2*(MOD(Data!$H$2:$H$4500,1)>=0/24.2)*(MOD(Data!$H$2:$H$4500,1)<23.999/24.2),SUM(SUMIFS(Data!$I:$I,Data!$C:$C,"L05 Cracks",Data!$D:$D,"LineDown")),)
    I tried this formula, but it only reads that the If statement is false. Any help on getting it to where I can set the time frame, would be much appreciated. The excel sheet has information in Sheet1 and Datadaily-downtime-september-january.xlsx
    Last edited by cmshawks2; 01-30-2015 at 03:09 PM.

  2. #2
    Registered User
    Join Date
    01-20-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    18

    Re: Conditionally summing values by single days and various conditions

    The sumifs section works, but I just cannot get it narrowed down by day. Any help would really be appreciated!!

  3. #3
    Registered User
    Join Date
    01-20-2015
    Location
    United States
    MS-Off Ver
    2010
    Posts
    18

    Re: Conditionally summing values by single days and various conditions

    Bump no response

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Summing values under conditions
    By midoo77 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-14-2013, 09:24 PM
  2. Summing values conditionally
    By dupaski in forum Excel General
    Replies: 2
    Last Post: 12-14-2008, 03:07 PM
  3. Summing Values Between Two Days
    By andrewc in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-05-2008, 11:29 AM
  4. [SOLVED] Conditionally summing cells based on conditions in other rows
    By Bert in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2006, 06:06 AM
  5. Summing values if conditions are true
    By mike camburn in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-12-2005, 05:45 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