Results 1 to 12 of 12

Sum values in Column A, based on dates in Column B & if value in Column C = True

Threaded View

  1. #5
    Forum Contributor
    Join Date
    11-15-2011
    Location
    UK
    MS-Off Ver
    Excel 2013
    Posts
    163

    Re: Sum values in Column A, based on dates in Column B & if value in Column C = True

    I did try to reformat cells but it half worked. Please find WB attached. I am trying to fill in the value in C2 on the 'Returns' sheet based on the Start and End Dates in A2 and B2. i.e. I want the sum of all invoices paid within that period.

    PS, it seems to have worked now that I have removed a lot of info from the sheet however certain values are still FALSE.
    Last edited by rtcwlomax; 05-25-2016 at 11:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count unique values in Column A, only if value in Column F falls between two dates
    By Sritcho in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-27-2014, 08:30 AM
  2. [SOLVED] Adding values in one column based on range of dates in another column
    By st_judeu@yahoo.com in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-02-2014, 08:54 AM
  3. Replies: 3
    Last Post: 03-22-2014, 08:35 AM
  4. Replies: 2
    Last Post: 06-06-2013, 08:29 AM
  5. Replies: 8
    Last Post: 04-19-2013, 12:06 PM
  6. Replies: 5
    Last Post: 09-24-2012, 05:14 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