+ Reply to Thread
Results 1 to 3 of 3

Sumifs using dates help

  1. #1
    Registered User
    Join Date
    03-08-2013
    Location
    Alpine,Texas
    MS-Off Ver
    Excel 2010
    Posts
    24

    Sumifs using dates help

    Hi Forum,

    I dont understand why my formula isnt working, its really simple im missing something.

    Here is what im trying to do ...My rain gage recorded many times per day making many entries, and i need to sum them up so they just use one row for each day with summed up amount rained.



    I have my spreadsheet attached, please help.

    Column K is where the accumulated rain for each day should be placed, or the sumif formula that is supposed to be working..
    Attached Files Attached Files

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Sumifs using dates help

    Try this one

    =SUMPRODUCT((INT($B$3:$B$989)=J3)*($D$3:$D$989))

    The reason it didn't match is because there are date and time in column J has dates only.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  3. #3
    Registered User
    Join Date
    03-08-2013
    Location
    Alpine,Texas
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: Sumifs using dates help

    Oh Sweet, thank you! this works great. thank ou AlKey.

+ 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. SUMIFS and Dates
    By martinezc5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-06-2014, 08:34 AM
  2. SumIfs Between two dates
    By adam2308 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-01-2014, 11:31 AM
  3. Sumifs between dates
    By rpiggott in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-11-2013, 03:40 PM
  4. Sumifs (criteria between two dates)
    By Arcanus in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-13-2013, 02:16 PM
  5. [SOLVED] SUMIFS Between two dates
    By nsens in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 01-17-2013, 06:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1