Results 1 to 8 of 8

Sumif and Weekday function combined

Threaded View

  1. #1
    Registered User
    Join Date
    04-09-2015
    Location
    new york
    MS-Off Ver
    2010
    Posts
    18

    Sumif and Weekday function combined

    Hello,

    First time posting, would appreciate some help.

    I have a column with dates filled in vertically, lets say 10 or so dates. Lets call this column A. Each date has a corresponding $value in the column next to it. Lets call this column B. So 10 dates, and 10 $values. To the right I have ONE row with 10 dates, in each column heading (Column D through M), each date is 7 days apart. So for example, the first date is 4/9/2015, second date is 4/16/2015, etc all the way to the 10th date.

    So I want to create a sumif function where the equation looks at all the dates in the left column (column A) and compares it with the heading date in the row in the first column (column D). If any of the dates in the vertical column (Column A) are within that first week, then sum the corresponding values in the left column. They must only be within those 7 days. Then we move on to the second column, in the row, and the values have to be between 4/9/15 and 4/16/2015, and so forth.

    Basically i'm creating a 10 week cashflow statement and I want to know in which week the account receivables will be due and I want to avoid double counting. Thanks.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] SUMIF function combined with INDEX/MATCH
    By nickiw579 in forum Excel General
    Replies: 7
    Last Post: 01-27-2015, 11:40 PM
  2. [SOLVED] Sumif And countif combined function
    By Deventus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-27-2013, 05:11 AM
  3. If function combined with weekday
    By ImPerplexed in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-15-2013, 08:20 PM
  4. Sumif Weekday Help
    By Alice21 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 10-14-2011, 11:19 AM
  5. [SOLVED] sumif weekday
    By nicolas.schimpf@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2006, 03:40 PM

Tags for this Thread

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