+ Reply to Thread
Results 1 to 2 of 2

Sumif by date?

  1. #1
    Registered User
    Join Date
    03-15-2014
    Location
    Nashville, TN
    MS-Off Ver
    365
    Posts
    33

    Sumif by date?

    All;
    I am trying to come up with a formula that will sum all the numbers in column I (“net”) per day, in column E.
    For example, it sums all values on 1/19/17, 1/20/17, etc.
    I’m sure there is a way, I seem to struggle with these “running” formulas. Sample attached.

    Maybe I'm trying to skin the cat the wrong way; but I want a formula I can run to show total amount of weight picked up (column I) per day (column E).

    Thanks ahead.
    Attached Files Attached Files

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,737

    Re: Sumif by date?

    a pivot table would do that quickest

    have you used pivot tables?

    see attached
    sheet1 - is that the result you are after?

    edit - need to modify the sheet - too much to load here
    i'll edit and attach later
    Attached Files Attached Files
    Last edited by etaf; 01-21-2017 at 01:38 PM.
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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. Replies: 8
    Last Post: 12-20-2015, 11:46 PM
  2. [SOLVED] Sumif date is blank or earlier than current date
    By cp49321 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-13-2013, 01:40 PM
  3. SUMIF by Date - SUMIF by Date = #VALUE when linked worksheet not open
    By alexhartley in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-14-2013, 03:56 AM
  4. [SOLVED] Sumif when range is date + time and crieteria is date
    By lokpal.panwar in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-05-2013, 06:46 AM
  5. [SOLVED] SUMIF(By Date) - SUMIF(By Date)= #Value Error From Linked Data
    By Dragunov in forum Excel General
    Replies: 2
    Last Post: 05-17-2012, 11:22 AM
  6. Sumif two columns to get month-to-date and year-to-date
    By Reyan123 in forum Excel General
    Replies: 1
    Last Post: 03-30-2010, 07:51 PM
  7. [SOLVED] SUMIF within date range as a function of today()'s date
    By irvine79 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-06-2006, 01:00 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