+ Reply to Thread
Results 1 to 3 of 3

summing range in table

  1. 09-14-2018, 08:52 PM #1
    sdyer03
    sdyer03 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    GA, USA
    MS-Off Ver
    2013 and 365
    Posts
    11

    summing range in table

    please see attached workbook to see the data I'm working with.

    This is related to summing a range in column 2 based on the year difference in column one. What I will have are two different years and I want to sum everything inbetween them.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-14-2018, 09:12 PM #2
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: summing range in table

    Hi sdyer,

    See the attached that has a SumIfs formula that I think solves your problem.

    SumIfs between 2 dates.xlsx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  3. 09-15-2018, 10:36 AM #3
    sdyer03
    sdyer03 is offline
    Registered User
    Join Date
    06-23-2015
    Location
    GA, USA
    MS-Off Ver
    2013 and 365
    Posts
    11

    Re: summing range in table

    EUREKA!

    Thanks.

    Stephen
    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. Need help in summing up parts of table
    By unam1978 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2015, 03:47 PM
  2. [SOLVED] Summing a range if cell in another range contains string
    By Caugello in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-18-2014, 12:27 PM
  3. Using countifs with date range, and summing values in that range
    By bmcoonan in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-30-2013, 11:28 AM
  4. Question: Summing the length of all cells in a range with Criteria in another range
    By rtiger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-26-2013, 03:38 PM
  5. Summing a range if cell in another range contains string
    By fleeting in forum Excel General
    Replies: 6
    Last Post: 05-04-2011, 12:09 PM
  6. summing specific range-how to sum with spesific range ?
    By joe23one in forum Excel General
    Replies: 0
    Last Post: 08-07-2007, 07:40 AM
  7. summing table values with multiple criteria from a dynamic table
    By griffith in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-06-2005, 05:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1