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.
Bookmarks