+ Reply to Thread
Results 1 to 8 of 8

SumIF - HELP!

Hybrid View

  1. 07-10-2017, 04:01 PM #1
    Benny3
    Benny3 is offline
    Registered User
    Join Date
    05-07-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    12

    SumIF - HELP!

    Hello

    I am trying to create a sumIF statement to add up the previous 96 cells if the date changes. In the screen shot below I have range as the entire data set, the DATE criteria, but I dont know what to do for the [sum_range] which needs to be the previous 96 cells. This is electrical energy data that I am trying to convert 15 minute interval data to energy, and the previous 96 cells add up to one hour. Ultimately this formula I am trying to do should convert 15 minute interval data to daily kilowatt hour sum. Thanks for your help!!!

    =SUMIF(D3:D35235, DAY(A4)<>DAY(A3),(D3:D98))

    SUMIF.JPG
    Reply With QuoteRegister To Reply
  2. 07-10-2017, 04:07 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,941

    Re: SumIF - HELP!

    (How to) Upload a Workbook directly to the Forum
    (please do not post pictures or links to worksheets)
    • Click Advanced next to Quick Post button at the bottom right of the editor box.
    • Scroll down until you see "Manage Attachments",
    • Click the "Choose" button at the upper left (upload from your computer).
    • Select your file, click "open", click "upload"
    • Once the upload is completed the file name will appear below the input boxes in this window.
    • Close the Attachment Manager window.
    • Click "Submit Reply"
    Note: Please do not attach password protected workbooks/worksheets
    Ensure to disable any Workbook Open/Autorun macros before attaching!
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 07-10-2017, 04:29 PM #3
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: SumIF - HELP!

    You could probably just use an IF ( SUM ) instead. Something like this, entered on the row where your first date change is:
    Formula: copy to clipboard 
    =IF(A100<>A99,SUM(D4:D99),"")


    Otherwise we'll need a sample file,as stated above.
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.
    Reply With QuoteRegister To Reply
  4. 07-10-2017, 04:34 PM #4
    Jonmo1
    Jonmo1 is offline
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: SumIF - HELP!

    Isn't it just

    =SUMIF(A$3:A$35235,A3,D$3:D$35235)
    Reply With QuoteRegister To Reply
  5. 07-10-2017, 04:38 PM #5
    Benny3
    Benny3 is offline
    Registered User
    Join Date
    05-07-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    12

    Re: SumIF - HELP!

    Quote Originally Posted by Aardigspook View Post
    You could probably just use an IF ( SUM ) instead. Something like this, entered on the row where your first date change is:
    Formula: copy to clipboard 
    =IF(A100<>A99,SUM(D4:D99),"")


    Otherwise we'll need a sample file,as stated above.
    Thanks guys I got this one to work!
    Reply With QuoteRegister To Reply
  6. 07-10-2017, 05:09 PM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,563

    Re: SumIF - HELP!

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  7. 07-10-2017, 05:19 PM #7
    Benny3
    Benny3 is offline
    Registered User
    Join Date
    05-07-2017
    Location
    Chicago, IL
    MS-Off Ver
    2010
    Posts
    12

    Re: SumIF - HELP!

    Ah ok thanks
    Reply With QuoteRegister To Reply
  8. 07-11-2017, 05:55 AM #8
    Aardigspook
    Aardigspook is offline
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: SumIF - HELP!

    Glad we could help and thanks for marking the thread as Solved - it lets others know there's an answer here.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIF: don't understand that purpose of the OFFSET inside SUMIF
    By Vitalite in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-30-2017, 03:13 AM
  2. Trying to sumif across sheets. SUMPRODUCT(SUMIF(INDIRECT function returns #REF error!
    By thenormanizer in forum Excel General
    Replies: 2
    Last Post: 06-21-2017, 06:32 PM
  3. SumIf formula or Sumif with pivottable combined question
    By mcgleeuw in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2015, 01:05 PM
  4. Subtracting from the SUMIF with the difference from the SUMIF range
    By iamblue91 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-04-2014, 09:01 PM
  5. [SOLVED] Shorten SUMIF + SUMIF + SUMIF each with same reference range but different criteria???
    By HeyInKy in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-13-2014, 09:25 PM
  6. SUMIF or SUMIF's formula with multiple criteria
    By jackiemariee in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-30-2013, 06:19 PM
  7. Nested SUMIF statement or multiple SUMIF's
    By Dan27 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-17-2009, 06:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1