(Posted this earlier but hoping to simplify):
I'm trying to sum revenue listed in a table using a SUMIFs function filtering for two separate dates. One is the "Install Date" ('Revenue Data'!D:D) and the other is the "Date of Spend" ('Revenue Data'!B:B), which must be a certain number of days *after* the install date in the same row.
I need to filter and sum Revenue ('Revenue Data'!C:C) by the following - 1) The Install Date (D:D) being between two dates listed in the first worksheet, and 2) Date of Spend (B:B) being a certain number of days beyond the Install Date. (I am also filtering by the 'Network' in $A$3, but that's beside the question.)
This is the formula I'm using, as seen in Sheet1, cell C6. The problem comes at the end, when trying to sum all revenue from Dates of Spend that are (A6-1) days past the Install Date.
=SUMIFS('Revenue Data'!C:C,'Revenue Data'!A:A,$A$3,'Revenue Data'!D:D,">="&+$B$1,'Revenue Data'!D:D,"<="&+$B$2,'Revenue Data'!B:B,'Revenue Data'!D:D+A6-1)
or --> SUMIFS(Revenue, Source Network = Text in cell A3, Install Date is greater than date in B1 and less than date in B2, Date of Spend = Install date + a number of days listed in Column A).
So in a case where A6 at the end equals 2, it should return all revenue from users that 1) installed on any day within the B1-B2 range, and 2) paid something on the day after installing.
Help appreciated!!!!!
Bookmarks