I'm trying to sum revenue listed in a table using a SUMIFs function filtering for two separate dates - in this case the day a player installed an app (Column D in the second worksheet) and the day of actually paying money within the app (Column B). Please see the attached sheet which should make more sense.
I need to filter and sum revenue (Column C) by the following - 1) install date (Column D) being between two dates listed in the first worksheet, and 2) date of spend (Column B) being a certain number of days beyond the install date listed in Column D. The number of days is in Column A of the first worksheet. (I am also filtering by the 'Network' in Column A, but that's beside the question.)
This is the formula I'm using, as seen in cell C6:
=SUMIFS('iOS Revenue Data'!C:C,'iOS Revenue Data'!A:A,$A$3,'iOS Revenue Data'!D:D,">="&+$B$1,'iOS Revenue Data'!D:D,"<="&+$B$2,'iOS Revenue Data'!B:B,'iOS 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 installed on any day within the range and paid something on day (INSTALL DATE)+2-1, or the second day post-install, etc.
The part at the end is giving me a lot of trouble. I can't get the revenue to reliably sum from Dates of Spend that are a certain number of days past their respective Install Date.
Help?
Bookmarks